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 |
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 |
All times are GMT +1. The time now is 03:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com