View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Using a column of data from 1 worksheet to extract data from another worksheet

The only problem is the data in the second worksheet is always changing
with the products so it's not static data. That is why I have to have
it on a different sheet so when it downloads it can upload the current
products I need to find.
I think the Filter would work but if I have 100 product items on my
worksheet to look up, how is the filter going to accomplish that task?
Thanks
Brett