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.