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 |
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 |