Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you search within a document?
I am woundering how you search with in a saved document. I want to make a
spread sheet for my buisness on my supplies, my cost, and my mark up cost but there is over 200 so I was woundering how i can go into this saved document and just type in the item I am looking for and have it pop up with out having to scroll throu the list? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you search within a document?
The first thing you should look at is DataFilter. It may well do everything
you want. If you need more help, post back. Regards, Fred "Me2020" wrote in message ... I am woundering how you search with in a saved document. I want to make a spread sheet for my buisness on my supplies, my cost, and my mark up cost but there is over 200 so I was woundering how i can go into this saved document and just type in the item I am looking for and have it pop up with out having to scroll throu the list? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you search within a document?
"over 200" what?
Instances of an item? Worksheets? "Scroll through the list".............what list? Gord Dibben MS Excel MVP On Tue, 16 Mar 2010 18:07:01 -0700, Me2020 wrote: I am woundering how you search with in a saved document. I want to make a spread sheet for my buisness on my supplies, my cost, and my mark up cost but there is over 200 so I was woundering how i can go into this saved document and just type in the item I am looking for and have it pop up with out having to scroll throu the list? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I search for a word within a excel document | Excel Discussion (Misc queries) | |||
How do i add a search box to excel document! | Excel Worksheet Functions | |||
How do i add a search box to excel document! | Excel Worksheet Functions | |||
Search trhu whole document | Excel Discussion (Misc queries) | |||
Is there a way to search for info in your excel document? | Excel Worksheet Functions |