Search Through Multiple Tabs' Contents
 

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


--
mayers57
------------------------------------------------------------------------
mayers57's Profile: http://www.excelforum.com/member.php...o&userid=35653
View this thread: http://www.excelforum.com/showthread...hreadid=554366

Search Through Multiple Tabs' Contents
 

Versions 2002 and 2003 have this capability in EditFind 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

On Wed, 21 Jun 2006 19:10:00 -0500, mayers57
wrote:


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