Search workbook

[Nikwak]

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

Nikwak

 

[Dave Peterson]

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/

 

[Nikwak]

Thanks for this

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/