Search Through Multiple Tabs' Contents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mayers57 - 22 Jun 2006 01:10 GMT

I was wondering if someone can help me create a search form within m
excel workbook that would search through multiple tabs all at once an
display the results indicating which tab the info resides?
Thanks, Mik

Reply to this Message

Gord Dibben - 22 Jun 2006 01:48 GMT

Versions 2002 and 2003 have this capability in Edit>Find which display the
across workbook results in a dialog box.

If you want the info displayed outside the dialog box, like into a range of
cells on a sheet, you would require VBA

Gord Dibben MS Excel MVP

>I was wondering if someone can help me create a search form within my
>excel workbook that would search through multiple tabs all at once and
>display the results indicating which tab the info resides?
>Thanks, Mike

Reply to this Message