Prev: Help needed with a formula for dates in excel 2007
Next: How to replace formula with its result
From: Me2020 on 16 Mar 2010 21:07
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?
From: Fred Smith on 16 Mar 2010 21:21
The first thing you should look at is Data>Filter. It may well do everything
you want. If you need more help, post back.

Regards,
Fred

"Me2020" <Me2020(a)discussions.microsoft.com> wrote in message
news:A6B20D94-EBC2-49E6-9E4F-12727D8A0E50(a)microsoft.com...
>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?

From: Gord Dibben on 17 Mar 2010 14:11
"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
<Me2020(a)discussions.microsoft.com> 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?

 | 
Pages: 1
Prev: Help needed with a formula for dates in excel 2007
Next: How to replace formula with its result