Search whole workbook

S

Sheryl Joy

Does anyone know how to search an open workbook. It takes a long tim
to search each sheet.

eg. I have a list of people which is broken up into separate sheet
for each night they are attending a performance.

What is an easy fast way of searching all the sheets in that workboo
for a persons name instead of having to look in each shee
 
T

tghcogo

If you have Excel 2003 you can use "find", it has several option
including "within" which allows you to select sheet or workbook.

I don't know if earlier versions have this option.

TGHCOG
 
S

Sheryl Joy

Thanks Andy, I downloaded this Flexi Find and it works and saves me
heaps of time. I appreciate this.
 
Top