Excel Help
 

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.

Excel Help
 

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" wrote in message
...
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.

Excel Help
 

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" wrote in message
...
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.

Excel Help
 

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" wrote in message
...
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" wrote in message
...
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.

Excel Help
 

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" wrote in message
...
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" wrote in message
...
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.