Prev: Sum of two groups
Next: Formula shows as text
From: Jane Griffel on 21 Apr 2010 14:16
I have two customers with two different list of procedures on one report.
cell A1 has a drop down list of the customers when a certain customer is
chosen How do I write a formula so that when I choose Cutomer 1 only their
list of procedures show up in a drop down box in my procedure area.
From: Luke M on 21 Apr 2010 14:29
See Debra's article on dynamic validation:
http://www.contextures.com/xldataval02.html

--
Best Regards,

Luke M
"Jane Griffel" <JaneGriffel(a)discussions.microsoft.com> wrote in message
news:E2411A44-0F70-4DA1-91E8-DA9198C5F704(a)microsoft.com...
>I have two customers with two different list of procedures on one report.
> cell A1 has a drop down list of the customers when a certain customer is
> chosen How do I write a formula so that when I choose Cutomer 1 only their
> list of procedures show up in a drop down box in my procedure area.


From: Jim Thomlinson on 21 Apr 2010 14:31
Perhaps this...

http://www.contextures.com/xlDataVal02.html
--
HTH...

Jim Thomlinson


"Jane Griffel" wrote:

> I have two customers with two different list of procedures on one report.
> cell A1 has a drop down list of the customers when a certain customer is
> chosen How do I write a formula so that when I choose Cutomer 1 only their
> list of procedures show up in a drop down box in my procedure area.
From: Jane Griffel on 21 Apr 2010 14:55
WOW thanks for the help that is exactly what I needed.

"Jim Thomlinson" wrote:

> Perhaps this...
>
> http://www.contextures.com/xlDataVal02.html
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Jane Griffel" wrote:
>
> > I have two customers with two different list of procedures on one report.
> > cell A1 has a drop down list of the customers when a certain customer is
> > chosen How do I write a formula so that when I choose Cutomer 1 only their
> > list of procedures show up in a drop down box in my procedure area.
 | 
Pages: 1
Prev: Sum of two groups
Next: Formula shows as text