deleting rows based on cell value

I have 1 column of data. I would like to loop through the column, say the first 1000 rows, and delete all entries that begin with a certain value. So, for example, I would like to delete all rows within the column whose value begins with "G56" or "G57". I would also like to delete any empty rows. I am currently using auto-filter to do this but am looking for a method that is less time-consuming as the data set can get quite large.
Any help would be appreciated.

Hi,

What do you mean by a value of G56 or G57 ...???

Carim

If I have a column such as:

g56-17

g41-18
g57-19
g52-17
g57-200
g48-21

I would like to delete the rows for each entry that begins with G56 or G57 as well as delete any blank rows in between, over a defined range.

Ok then ...

Please Login or Register  to view this content.

HTH
Carim

Thank you. Works great!

Glad it fixed your problem.

Thanks for the feedback

Carim