How to search multiple worksheets in a workbook for information?

G

Guest

Let's say I have a workbook containing multiple worksheets, each a separate
materials requisition. I want to find out when (and details) I last ordered
a particular item. Other than selecting each worksheet one at a time and
then using "find," is there a search that would look through all the
worksheets in that particular workbook?
 
G

Guest

In Excel XP (& maybe earlier versions, too), the Find dialog box has an
Options button which, when clicked, gives you a dropdown where you can choose
to search either the Sheet or the Workbook. Does that meet your needs?

Duke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

consolidate workbooks to worksheets in one workbook? 1
Graphing data from multiple worksheets in same workbook 1
Unhide multiple worksheets in workbook 2
Linking multiple worksheets in one workbook 2
Excel workbook links 1
how do I search workbook for data 3
How do you apply a print area to an entire workbook 1
multiple workbooks in one file 3

Top