MS Excel 2000 - Data Delete Help Needed
 

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

MS Excel 2000 - Data Delete Help Needed
 

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

--
Don Guillett
SalesAid Software

"RES" wrote in message
om...
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