MS Excel 2000 - Data Delete Help Needed

  • Thread starter Thread starter RES
  • Start date Start date
R

RES

I have a worksheet that contaings 6 columns of information. One of the
columns is named "% complete". If a number in this "% Complete" cell
= 100, I would like to create a macro to remove this row from the
current worksheet and move it to another worksheet.

Can someone help me with this? I assume it would be done Visual Basic
but I'm not knowledgable on this.

Thanks
 
something like (untested)
for each c in range("a4:a400")
if c>=100 then entire.row move
sheets("sheet2").range("a65536").end(xlup).row+1
next
 
Back
Top