Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create search boxes in Excel | Excel Discussion (Misc queries) | |||
Create search in excel | Excel Worksheet Functions | |||
where can i create my own word search? | New Users to Excel | |||
How do I create a function to search a range for a number and... | Excel Worksheet Functions | |||
How do I create a "List If" function.I need to search a database . | Excel Worksheet Functions |