Search whole workbook

[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

 

[Andy B]

Hi

I would suggest using FlexFind:
http://www.jkp-ads.com/Download.htm#Flexfind
It is a very powerful search facility that is an Excel add-in.

 

[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

 

[Sheryl Joy]

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