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

"Rick Rothstein (MVP - VB)" wrote:

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


"Emily" wrote in message
...
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.

"Dave Peterson" wrote:

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.

Emily wrote:

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