Excel Help

[Glenn]

Can I change the content of a drop down list by an entry from another cell?
Example: The ranges C1:C5 has one set of names and D1:D5 has another set of
names. Depending on the entry in cell A1 for example, the drop list will
dynamically change to show either the list of names in C1:C5 or D1:D5.

[RagDyer]

You can create a 2 item drop-down list, with appropriate descriptions, where
the user can make a choice between the "C" list or the "D" list.
These are called dependent lists, and you can find out all about them from
Debra Dalgleish's web site at this page:

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

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Glenn" <Glenn@discussions.microsoft.com> wrote in message
news:54D48CAB-C194-423A-955F-BBF2AD342491@microsoft.com...
> Can I change the content of a drop down list by an entry from another
cell?
> Example: The ranges C1:C5 has one set of names and D1:D5 has another set
of
> names. Depending on the entry in cell A1 for example, the drop list will
> dynamically change to show either the list of names in C1:C5 or D1:D5.

[Jacob_F_Roecker]

Thank you thank you thank you thank you!!!

This is the best way I've seen to solve this problem yet.

With a little creativity I was able to get it to work on one of my sheets
that had two columns dependent upon the original category.

-Jacob F. Roecker

"RagDyer" wrote:

> You can create a 2 item drop-down list, with appropriate descriptions, where
> the user can make a choice between the "C" list or the "D" list.
> These are called dependent lists, and you can find out all about them from
> Debra Dalgleish's web site at this page:
>
> http://www.contextures.com/xlDataVal02.html
>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Glenn" <Glenn@discussions.microsoft.com> wrote in message
> news:54D48CAB-C194-423A-955F-BBF2AD342491@microsoft.com...
> > Can I change the content of a drop down list by an entry from another
> cell?
> > Example: The ranges C1:C5 has one set of names and D1:D5 has another set
> of
> > names. Depending on the entry in cell A1 for example, the drop list will
> > dynamically change to show either the list of names in C1:C5 or D1:D5.
>
>

[RagDyeR]

Appreciate the feed-back,
And I'm sure Debra appreciates your enthusiasim.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Jacob_F_Roecker" <JacobFRoecker@discussions.microsoft.com> wrote in message
news:937BB846-4938-48ED-A419-51B4DADB0CFA@microsoft.com...
Thank you thank you thank you thank you!!!

This is the best way I've seen to solve this problem yet.

With a little creativity I was able to get it to work on one of my sheets
that had two columns dependent upon the original category.

-Jacob F. Roecker

"RagDyer" wrote:

> You can create a 2 item drop-down list, with appropriate descriptions,
where
> the user can make a choice between the "C" list or the "D" list.
> These are called dependent lists, and you can find out all about them from
> Debra Dalgleish's web site at this page:
>
> http://www.contextures.com/xlDataVal02.html
>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Glenn" <Glenn@discussions.microsoft.com> wrote in message
> news:54D48CAB-C194-423A-955F-BBF2AD342491@microsoft.com...
> > Can I change the content of a drop down list by an entry from another
> cell?
> > Example: The ranges C1:C5 has one set of names and D1:D5 has another set
> of
> > names. Depending on the entry in cell A1 for example, the drop list
will
> > dynamically change to show either the list of names in C1:C5 or D1:D5.
>
>

[Jacob_F_Roecker]

I can't answer people's questions as well as the MVP community yet--I'm
working at it--but at least I can add a little of my own character to the
group.


"RagDyeR" wrote:

> Appreciate the feed-back,
> And I'm sure Debra appreciates your enthusiasim.
> --
>
> Regards,
>
> RD
> ----------------------------------------------------------------------------
> -------------------
> Please keep all correspondence within the Group, so all may benefit !
> ----------------------------------------------------------------------------
> -------------------
>
> "Jacob_F_Roecker" <JacobFRoecker@discussions.microsoft.com> wrote in message
> news:937BB846-4938-48ED-A419-51B4DADB0CFA@microsoft.com...
> Thank you thank you thank you thank you!!!
>
> This is the best way I've seen to solve this problem yet.
>
> With a little creativity I was able to get it to work on one of my sheets
> that had two columns dependent upon the original category.
>
> -Jacob F. Roecker
>
> "RagDyer" wrote:
>
> > You can create a 2 item drop-down list, with appropriate descriptions,
> where
> > the user can make a choice between the "C" list or the "D" list.
> > These are called dependent lists, and you can find out all about them from
> > Debra Dalgleish's web site at this page:
> >
> > http://www.contextures.com/xlDataVal02.html
> >
> > --
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> >
> > "Glenn" <Glenn@discussions.microsoft.com> wrote in message
> > news:54D48CAB-C194-423A-955F-BBF2AD342491@microsoft.com...
> > > Can I change the content of a drop down list by an entry from another
> > cell?
> > > Example: The ranges C1:C5 has one set of names and D1:D5 has another set
> > of
> > > names. Depending on the entry in cell A1 for example, the drop list
> will
> > > dynamically change to show either the list of names in C1:C5 or D1:D5.
> >
> >
>
>
>