G
Guest
Is there a way to find data on multiple worksheets instead of searching individual worksheets?
K
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
----------------------------------------------------------------------------
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
----------------------------------------------------------------------------
individual worksheets?fnfuser said:
G
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
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