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