Search Through Multiple Tabs' Contents

  • Thread starter Thread starter mayers57
  • Start date Start date
M

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default Search Options 2
Counting multiple memberships 1
Merging of multiple lists 1
Moving Subform to Tab Control 3
Work laptop issues 4
Tabs + Subforms + Data Entry = No Go 0
Form won' tab through properly 1
saving a windows form and it's content to reload later. 3

Back
Top