select and delete specific rows

I have a text report I import into excel that has headers and blank rows between the headers.

I need some code to delete rows that begin with specific words, such as "subscriber", or "Payment type", and also deletes any blank rows.

Thanks

without code try this:

suppose your data is in column B (if not add a column at right of your data column), put 1 in column A to the right of cells that you want to delete (whole row) and also put 1 on right of cells that are empty, when you have entered 1 in the right of cells that you want to delete, select column A and press F5 to open Go To window > press Special tab and click Constants and then Ok. it will select cells that contain 1 (actually these cells are in rows that you want to remove) now press Ctrl+- (Ctrl and minus sign) it will open a Delete window, select Entire row and click Ok. All rows will be deleted which contain 1 in col A.

hope this would serve your purpose.

Originally Posted by Paulg

I have a text report I import into excel that has headers and blank rows between the headers.

I need some code to delete rows that begin with specific words, such as "subscriber", or "Payment type", and also deletes any blank rows.

Thanks