Search workbook

  • Thread starter Thread starter Nikwak
  • Start date Start date
N

Nikwak

Is there any way to search an entire workbook for an entry rather than
having to search through each individual worksheet?

Nikwak
 
In xl2k, you can group the sheets before you do edit|find. (Click on the first
and ctrl-click on subsequent--or right click on a worksheet tab and choose
select all sheets).

In xl2002+, you can specify "within workbook" under the options button on the
find dialog.

In all versions, you could use Jan Karel Pieterse's FlexFind:
http://www.bmsltd.ie/MVP/
 
Thanks for this

Nikwak

Dave Peterson said:
In xl2k, you can group the sheets before you do edit|find. (Click on the
first
and ctrl-click on subsequent--or right click on a worksheet tab and choose
select all sheets).

In xl2002+, you can specify "within workbook" under the options button on
the
find dialog.

In all versions, you could use Jan Karel Pieterse's FlexFind:
http://www.bmsltd.ie/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

replace state names with state code abbreviations 3
Hyperlinks 3
How do I search a whole workbook using the =INDEX function? 3
How can I copy and paste an entire workbook? 3
find 1
Using data from multiple worksheets in a formula 1
How do I save multiple worksheets as individual documents? 1
One workbook with 62 worksheets 11

Back
Top