I can send you a workbook that does basically what you want through the use of
Input Box that user types text or a number into.

Uses wild cards for search criteria.

Email me and I will send to you.

Change the AT and DOT for my address.

gorddibbATshawDOTca


Gord Dibben MS Excel MVP

On Fri, 5 Oct 2007 14:09:00 -0700, Emily
wrote:

The person that is going to have to use the Inventory sheet is not good with
computers and gets really confused, also it will not bring up all things
related to the search. For example I want to be able to type in 3/4 and have
everything returned to me such as: #3/4, 1 3/4'', 3/4reel, ect


"Gord Dibben" wrote:

And you decided against Autofilter because???

Gord

On Thu, 4 Oct 2007 21:20:01 -0700, Emily
wrote:

A pop up box would work, if it had a scroll list. Even going to the
inventory sheet would work if it was sorted with the returned items on the
top of the list.

"Gord Dibben" wrote:

Where and how would you like it "shown"?


Gord Dibben MS Excel MVP

On Thu, 4 Oct 2007 20:43:01 -0700, Emily
wrote:

I want to, say create a box and in that box be able to type a word, then
have
everything in my inventory related to that word be shown to me