Search worksheets within a database...How?

  • Thread starter Thread starter texcel
  • Start date Start date
T

texcel

Hello and Good day,

Simple question...is there a way to search all the cells inside every
worksheet of an Excel File?

For instance:

I have an excel file that contains phone numbers and there are SEPERATE
worksheets that contain all the numbers of a particular category such
as Family, Friends etc..

How can I, from any of the worksheets within the Excel File, search for
a specific name?

I know how to do a search on a worksheet when it is the one open and
displayed (Macintosh: Command (Open Apple) F) but want to search ENTIRE
FILE from one page.

Please help

Thanks
 
'Texcel',

This is quite easy once you know it:

Just select the first sheet in the workbook, then hold the [Shift] button
and select the last sheet
in the workbook. Now you search on all selected worksheets, which is all
worksheets in this case.
Be careful though, because if you have got all sheets selected and you want
to edit a cell... you will
edit the same cell for EVERY worksheet.... so make sure you select one
worksheet again before
editing!

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl
 
Tex

In XL97 the Find across grouped worksheets does not work well, if at all,
although Replace across worksheets functions OK.

Download Jan Karel Pieterse's FLEXFIND.XLA from Stephen Bullen's website to
get full functionality on all versions.

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

Gord Dibben Excel MVP
 
Back
Top