"Global" search in a workbook?

G

Görel

I have a large workbook with several sheets with similar
contents. I need to search for various text strings in the
workbook and want to find all occurrences, regardless which
sheet they're on. The only way I have managed is to open
one sheet at a time and search for the string, which is
extremely tedious.

Is there a way to perform as "global search" in a workbook?
That would help me a lot!

Thanks,
Görel
 
A

Andy B

Görel

Do a search for flexfind on google. This is an add-in that will list all
occurrences of each find, in a dialogue box.

Andy.

I have a large workbook with several sheets with similar
contents. I need to search for various text strings in the
workbook and want to find all occurrences, regardless which
sheet they're on. The only way I have managed is to open
one sheet at a time and search for the string, which is
extremely tedious.

Is there a way to perform as "global search" in a workbook?
That would help me a lot!

Thanks,
Görel
 

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

Formula Audit mode active in one column only; cannot kill. 2
WORD VBA Search and switch to advanced ... 1
"Global" search in a workbook 2
How do I set focus (and select text) on a text box on a modeless userform? 0
Locking Pages and/or Workbook 1
Global Template Network and saving auto texts & macros 2
cannot find which label format i need 1
Macro VBA coding, Copying content from one workbook to a new one 0

Top