Delete rows Macro

I have a huge spreadsheet that I want to be able to sort through and delete the unwanted rows. I want to do a search for anything in column C that equals 2225 including the next row after and delete the rest. Here is an example.

A B C D
1 ac dfe 2225 55
2 ac esf 1232 32
3 fg we 3454 25
4 is po 2225 12
5 is esf 7584 32
6 fg we 7480 25

I want to keep all rows that contain 2225 in Column C, including the next row. So I want a macro to go through and keep rows 1, 2, 4, 5 and delete 3 and 6.

Please Login or Register  to view this content.