find on multiple worksheets

[fnfuser]

Is there a way to find data on multiple worksheets instead of searching individual worksheets?

 

[Ken Wright]

Depending on your version (2002 onwards), Edit / Find / Options / Change 'Within
Sheet' to Within Workbook'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Is there a way to find data on multiple worksheets instead of searching

individual worksheets?

 

[Gord Dibben]

Find across sheets was unreliable to non-existent in Excel 97.

I believe 2000 was capable and certainly 2002 does the trick.

Jan Karel Pieterse's FLEXFIND.XLA is a handy add-in for this purpose.

Can be found and downloaded from Stephen Bullen's website.

http://www.bmsltd.co.uk/MVP/Default.htm

Gord Dibben Excel MVP