Search Through Multiple Tabs' Contents

[mayers57]

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

 

[Gord Dibben]

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