How to search multiple worksheets in a workbook for information?

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?

Download Jan Karel Pieterse's FlexFind.
You can find it here:
http://www.oaltd.co.uk/MVP/


medic2816 wrote:
>
> 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?

--

Dave Peterson

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

"medic2816" wrote:

> 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?