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