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?