How to create a search function
 

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

How to create a search function
 

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

How to create a search function
 

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

How to create a search function
 

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

How to create a search function
 

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

How to create a search function
 

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

How to create a search function
 

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

How to create a search function
 

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

How to create a search function
 

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

How to create a search function
 

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