Search multiple worksheets - Excel 97
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.
|