does sorting based on a large filter list require a macro?

My problem is i get updated price lists from a supplier with thousands of products, of which I only sell about 150. I want a sort that will bring my items out each time I get the new price list. Here is pseudocode for what I need: While (ProductName)
If ProductName (is a member of) ActiveProductsList THEN
Dump (ProductName ROW) in a new results worksheet
GOTO next row

Sorry, not a programmer so pseudo code is not pretty.

Anyway...is there a built-in function that will do this...I can't seem to find one, if not does anyone know of a free example macro out there ... I have googled for a half hour with no luck...not sure how to word what I am looking for anyway.

Thanks

It sounds like you need a filter rather than a sort.
If you have a list of the products you are interested in, you can use that list with Advanced Filter to view only those items.

well, shows my excel ignorance...that was the tool i needed. thanks a mil. Hope to post harder questions in the future as I am planning on implementing a Filemaker inventory system linked to Excel spreadsheets.

You're welcome.