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

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

On Wed, 21 Jun 2006 19:10:00 -0500, mayers57
<mayers57.29s1io_1150935010.9217@excelforum-nospam.com> 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