If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
adding a search box to a spreadsheet
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 |
Thread Tools | |
Display Modes | |
|
|