searching excel with a form and returning the results
 

Hi;

I need to create a single excel sheet to search a table of items and return
the results. I was thinking of having a sheet with three tabs. The first tab
would have the table. Each row of the table would represent an item with
three fields; location, shelf (within the location) and description. The
description field would act as a key since it uniquely identifies a table
row. The second tab would have a form consisting of a text box that the user
could enter the description. There would also be two buttons "search" and
"reset". The search button would start at row one and see if the text in the
text box was in each item descrition field. In addition to an exact match,
I'd like it to get partial ones such as entering "wrench" would return
"wrench", "monkey wrench", "cresent wrench", etc. When a row was found as a
match, it would be put in the third tab. Thus, the third tab would hold the
matching rows (like a recordset in database terminology). They could then be
printed.

I would like to know if my approach can be done in Excel and if so, what
might the search button code look like? Any help is greatly appreciated.

Thanks

jjfjr
--
JJFJR