View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default scanning worksheet for data then adding it

I'm not sure this is what you want, but perhaps:
Set up the list of products on sheet #1 as a Named Range so that it can be
used as a data validation list on another sheet. In sheet #3, select a group
of cells where you want to be able to select the product(s) from and pull
related data from sheet 1. Set those up with Data | Validation using the
list on sheet #1 as the list source - this guarantees you always 'type' them
properly without error. In the cells next to each of those, set up VLOOKUP()
formulas to pull the data from sheet #1 that you need.

This workbook shows this process in action, and tells how it was set up,
click the link and save to your hard drive and take a look at it. Link is
one continuous line, if it doesn't seem to work, copy it all and paste into
your browser's address bar:
http://www.jlathamsite.com/uploads/D...arateSheet.xls

"Steve" wrote:

So...I have a workbook with multiple worksheets. In the first worksheet,
there are a number of rows and columns...it's a forecast worksheet.
One of the columns contains product names. I want to, from another
worksheet, scan the list (column) for one of the products and take that row
and add it to the worksheet I'm working on.
So, for example, if a workbook contains 3 worksheets and I'm working in #3
but #1 contains the data I want.
Worksheet #1 has a column with Microsoft products...it would be 1 or more
products. So, a column could say "Excel" or "Excel and Word" (without the
quotes).
I want to work in worksheet 3 and scan the "products" column to find each
one that has the word "Excel" in it then take that row and populate rows in
worksheet #3.
I hope this makes sense. Thanks!