Good Morning,
Wondering if anyone can help me build a macro? This is for charity and I'm under some time contraints to format a .xls ready for label printing
Quandary: Delete every row containing "P0". Most lines have 3 non"P0" lines in between but every now and then there are 4.
Example:
1 P000001
2 Kim
3 Address
4 City, Prov,PC
5 P000002
6 Joe
7 Address
8 City, Prov, PC
9 P000003
10 Sally
11 Address
12 City, Prov, PC
13 P000004
14 Mike
15 Jane
16 Address
17 City, Prov, PC
18 P000005
A milliong THANKS!!!!!!!!!!
Bookmarks