I find it easier to keep all my data on one worksheet.

If you do that, you can select your range and do Data|filter|autofilter.

Then you can use the dropdown arrows to choose what you want to see.

If you really need to put that info on another sheet, you could copy and paste
the visible rows.

(and if you need a macro, record one when you do it manually)

" wrote:

Alright,
This is my first post to the group!!
Here is what I have to get it started:
Worksheet(Manuf#) 26025 records (Product#, Description,Buyline, Manuf#)
Worksheet(Products) various amount of product ID's in column A(only
column of data), this all I want to have in this worksheet, just the
list of products I want to find from Manuf#.

So what I need is a macro, Module, whatever it will take so I can look
at the Products in Worksheet(Products) and extract just those Records
from Worksheet(Manuf#) into a new Worksheet named Results?

Any help at this time would be greatly appreciated.
What i have so far is a Input box so I can input the product I want and
it will create a new Worksheet with that one product, but each time I
do the Input it creates a new Worksheet.

Thanks

--

Dave Peterson