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.