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


--
Paulg
------------------------------------------------------------------------
Paulg's Profile: http://www.excelforum.com/member.php...o&userid=36077
View this thread: http://www.excelforum.com/showthread...hreadid=574204

select and delete specific rows
 

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.

Paulg Wrote:
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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=574204