Thread
:
MS Excel 2000 - Data Delete Help Needed
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]