Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Macro to erase particular rows in a given pattern
I need a Macro to erase particular rows in a given pattern, but I can't find one on the web. We are testing a new data collector and the raw data can be opened in Excel. The problem is, we have 30000+ rows of data, but we only need rows 1, 5, 9, 13, 17, 21 and so on... deleting every three rows manually is taking forever. I have to say I'm not used to the macros, but I think I can figure out how to run one using the spreadsheet. Can someone give me any suggetsions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows in A Pattern | Excel Discussion (Misc queries) | |||
Deleting Rows in a Pattern | Excel Discussion (Misc queries) | |||
Deleting Rows In A Pattern | Excel Discussion (Misc queries) | |||
Erase duplicate rows | Excel Discussion (Misc queries) | |||
Can a macro erase it's self after a set criteria? | Excel Worksheet Functions |