Search multiple worksheets - Excel 97

[Guest]

Hi,

Is it possible to search for text in multiple worksheets within the one
workbook in Excel 97 (I know, my company is woefully out of date!!)?

I have 13 worksheets and want to search for a person's name or a reference
number in the entire workbook so that it will go directly to the worksheet
and cell.

Ctrl+f cannot do this and I've tried FIND, SEARCH all to no avail.

Any ideas??

Many thanks in advance.

Fybo.

 

[Norman Jones]

Hi Fybo,

Look at Jan Karel Pieterse's excellent FlexFind addin which is freely
downloadable at:

http://www.jkp-ads.com/Download.htm

 

[Guest]

Try right clicking on a worksheet tab and select all
Then see if Find would work.
I do not have a copy of excel97 to run this test. If not...
The find might remember the search pattern so you might be able to change
worksheets with the Find window up.

 

[Guest]

Try right clicking on a worksheet tab and select all
Then see if Find would work.
I do not have a copy of excel97 to run this test. If not...
The find might remember the search pattern so you might be able to change
worksheets with the Find window up.

Thanks! Sounds good, give a try after the weekend.