Hello all

Here's the deal. If "Customer Name:" exists in COL A, keep the row.
if "Customer Totals" exists in B, keep those rows too.

Delete ALL the rest. "Customer Name:" and "Customer Totals" NEVE
appear together on the same row.

Here's what I've started with:

Dim x As Long
For x = 1 To Range("A65536").End(xlUp).Row
If Range("A" & x) < "Customer Name:" Then
Range("A" & x).EntireRow.Delete
Else
Range("A" & x).EntireRow.Delete
End If
Next

Of course, this will delete the "Customer Totals" rows before th
macro has time to KEEP those rows. Can someone help me merge this wit
"keep COL B If Customer Totals exists?"

Thanks for reading

--
Message posted from http://www.ExcelForum.com