Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you search by column or row within a spreadsheet? | Excel Worksheet Functions | |||
Search for TRUE in spreadsheet | Excel Discussion (Misc queries) | |||
Adding a search box | Excel Discussion (Misc queries) | |||
Search Spreadsheet for a name | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) |