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.