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