Thank you for the reply. The lists I am working with are over 2500 rows long
though, with more extraneous rows than pertinent ones. I have to start out
with them to get all the relevant info on the items I want to use. I want to
be able to perform the same actions on multiple lists quickly too.

I am learning that the AutoFilter command is more versatile than I had first
thought. And searching this forum has turned up links to some good macros.

Now, I am having problems getting the AdvancedFilter to detect my criteria.
When I run it, it copies over the entire list. I have selected "Copy to new
location" so that I could see it is actually doing something. I had to read
the About Filtering help page to figure out what to put in the Criteria Range
(I thought). I don't get error messages anymore, but it results in an
identical copy of the original list. I am about to start searching for an
answer to that problem or how to write a macro for the "right-click, Delete"
solution.

Thanks again



"Roger Govier" wrote:

Hi

Mark your header row, DataFilterAutofilter
Use the dropdowns on each of the 2 columns to select the rows meeting
the criteria you want.
When you have the rows you want to remove as the only visible rows on
the screen, select the entire rows by clicking on the row numbers, Right
clickDelete row

DataFilterShow All

--
Regards

Roger Govier