Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
* I would like it to ignore row 1, because it is the header row.
* Then I want to go through a massive Excel document and delete each row that doesn't contain a specific string of text (which happens to be in column 1). FOR EXAMPLE: -- if a row has MyOldStuff in column 1 then delete the entire row, -- if a row starts with MyNewStuff then keep the entire row (i.e. do nothing and move on to the next row) ------ I hope that this is the right place to ask, and I'd like to thank anyone who can guide me in advance! This is a very long spreadsheet, with thousands of rows |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to Write and delete value in registry | Excel Programming | |||
how to write to macro to only delete rows under certain conditions | Excel Programming | |||
Delete rows from a protected sheet (write macro) | Excel Programming | |||
How do I write a macro to delete all rows from the first empty ro. | Excel Programming | |||
How do I write a macro in XL that will delete 1st row and save th. | Excel Programming |