How to create a search function

[Guest]

I don't know if there is a function for this or how to create one, but I want
to be able to search my inventory list. I would like to be able to, type in
"Zanes" then have all things related to that word shown to me, such as: stock
#, Quanty, Reels, Spools, and so on. If I were to type in "reels" then I
would like to be able to see all the reels, that are in my inventory. I hope
this makes sence.

Thank you
Emily

 

[Dave Peterson]

Not quite what you're asking, but maybe you could apply Data|Filter|autofilter
to your range.

Then you could filter to show the rows you want.

 

[Guest]

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. I don't want
to have to use the filter option. Kind of like when you type a word into
google and it showes you all related items, well I want to be able to do that
in an Excel worksheet, or even the whole workbook.

 

[Rick Rothstein \(MVP - VB\)]

Does using Excel's "Find All" do what you want? Click Edit/Find on Excel's
menu bar, type in your inventory word and click the Find All button. You
will get a mini-sheet showing all the data having that word in it. If you
need addition control over the search, click the Options button on the Find
dialog.

Rick

 

[Guest]

Sort of. I don't want the user to have to use "find all" but that is the
idea I am looking for

 

[Gord Dibben]

Where and how would you like it "shown"?


Gord Dibben MS Excel MVP

 

[Guest]

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]

And you decided against Autofilter because???

Gord

 

[Guest]

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]

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