| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete old excel files that aren't needed anymore? | Excel Discussion (Misc queries) | |||
| RE Excel: Once a list is created, how do you delete it if needed? | Excel Worksheet Functions | |||
| Regexp needed in Excel 2000 | Excel Discussion (Misc queries) | |||
| How to delete duplicate rows in Excel 2000? | Excel Discussion (Misc queries) | |||
| Help needed with textbox formatting in Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
