Delete 2 rows skip 1 delete 2 more
I know you said you wanted a macro, but if you are only doing this once, it
only takes 30 seconds to do it manually:
- Add a helper column
- In the 1st three cells of that column enter A, B, C.
- Copy those 3 cells down the length of your data
- Sort on the Helper column.
- Delete A's & B's
HTH,
--
George Nicholson
Remove 'Junk' from return address.
"jared" wrote in message
oups.com...
I am looking to have a macro delete 2 rows then skip 1 row and delete
the next two. I have over 18,000 rows and I really would rather not do
this the manual way. :)
Thanks,
Jared
|