How do I search for a string across multiple worksheets in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
What version of Excel?

97 has a problem searching(find) across grouped worksheets.

No problem with the Replace feature.

Newer versions work OK.

Make sure you have "within workbook" enabled in the Find Options.

If you are running version 97, download Jan Karel Pieterse's FlexFind add-in.

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


Gord Dibben Excel MVP
 
Thank you!!!!

Gord Dibben said:
What version of Excel?

97 has a problem searching(find) across grouped worksheets.

No problem with the Replace feature.

Newer versions work OK.

Make sure you have "within workbook" enabled in the Find Options.

If you are running version 97, download Jan Karel Pieterse's FlexFind add-in.

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


Gord Dibben Excel MVP
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Totals Across Multiple Worksheets 2
Editing an "IF" function across a worksheet/excel file 2
COUNTIF across worksheets 3
SUMIF across multiple worksheets. 3
Countifs for multiple worksheets 4
Average across worksheets ignoring zero 2
fill data across worksheets 1
search function 2

Back
Top