perform search through all worksheets with one formula

  • Thread starter Thread starter Dave W
  • Start date Start date
D

Dave W

I'm hoping that someone can point me in the right
direction to lookup a formula that would search for
specific criteria listed in all of the worksheets
in my workbook. I'm trying to gather specific cell names
and have them report to a cover letter.

Thanks
 
Dave W
Your question is a little vague. My answer is based on the following
assumptions.
1. These certain cells on your worksheets don't move. The information
you want transfered to your report sheet is always found in say cell
B2.
2. Where you want the transfered information to end up on your report
sheet is always the same.

Go to each sheet you want information from and Name that cell or cells
that contain the information you want to put on the report sheet.
You name cells or ranges of cells by first selecting the cell or cells
and then going to the menu INSERT>NAME>DEFINE, which opens a dialog box
with a place to give this cell or group of cells a name. Tip: Can't
have any spaces in your name, you can use the underscore_ to separate
words if you want to.
So this for each sheet and for each bit of info you want on the report
sheet.
Next go to the report sheet and select where you want the information
to go. In that cell enter the formula = ONE OF YOUR NAMES that contain
the information you want at that location.
Tip:When you select the cell you want to put your named information
into and type "=" then go to INSERT>NAME>PASTE and select one of your
names.

Hopes this helps
Casey
 
Back
Top