hey everyone,

Everyday I have to do the same thing on excel, one of those jobs is to retrieve specific rows of data from a file that is 6000 rows long... What I do is:

-sort the data by 'Part Number' (column E)
-Select all rows where part number starts with anything other than "D" or "V"
-delete those selected rows (but not deleting the 1st row)

by now I have a data set the consists of just rows with Part #s that begin with D and V.. then I do some other stuff that is not relevant to this code.

So I'm sure there must be a way to code this in VBA instead of doing it manually everyday... i found this website which has code that deletes rows, based on what you tell it to delete, but I need the opposite, I want to tell it what not to delete and have it delete everything else (except the first row).
HTML Code: