adding a search box to a spreadsheet

I have a workbook with 92 tabs containing data and text. i would like to add
a search box to my index tab. This search box would allow a user to type in
what they wanted to find without having to search so many tabs for a given
name.

Example: If the name "jones" was on several sheets in the workbook I would
like to be able to type in the word "jones" in the search box located on the
index sheet and have the search return all "jones" entries.

Thanks
john

Excel already has that feature.

You can search across the entire workbook.

Under EditFindOptionsWithin you can select "workbook".


Gord Dibben MS Excel MVP

On Sun, 30 Nov 2008 14:49:24 -0800, Adding a search box to a spreadsheet
Adding a search box to a spreadsheet @discussions.microsoft.com wrote:

I have a workbook with 92 tabs containing data and text. i would like to add
a search box to my index tab. This search box would allow a user to type in
what they wanted to find without having to search so many tabs for a given
name.

Example: If the name "jones" was on several sheets in the workbook I would
like to be able to type in the word "jones" in the search box located on the
index sheet and have the search return all "jones" entries.

Thanks
john