Excel Help

[Guest]

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 D15 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 D15.

 

[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!
==============================================

 

[Guest]

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]

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 !
----------------------------------------------------------------------------
-------------------

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

 

[Guest]

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.