bonnepoutine
New Member
- Joined
- Nov 24, 2010
- Messages
- 15
I have a database that is primarily used to convert data using VLookup, the database is on a seperate workheet to avoid giving users access to the entire database. I would like to include a ''Search Box'' or some kind of ''find Box'' which would allow users to enter a word and have it bring up all the cells that contain the specified word. I do not want to use the classic ''Find All'' (CTRL+F) as I don't want users to see the entire list, and I don't want them to have to go through each ''find'' one at a time. Is it possible to simply have a search box that will bring up a list of each cell containing the serched word (either on a seperate worksheet or in some kind of ''box''). Some serches will only ''find'' one entry but others may bring up 100 matches.
Thanks in advance !
Thanks in advance !