Excel VBA Row Delete

[andyaf]

Hi,

I need to remove a series of rows in a 20,000+ row spreadsheet based on a set criteria. The file attached is a sample. In the "Fish Y/N" column, some rows contain the number "0" instead of a "Y" or "N." I'd like some sort of a VBA or formula that can help me completely eliminate the row and shift the bottom row in it's place.

How can this be done?

Thanks for the help!

[oeldere]

Without VBA

filter on column D and select the data with a 0.

After that you can delete those (selected) rows.