How do I create a dependent list, to a current list?
 

I am trying to create a dependent responing list to another drop down list in
excel.

I.e.
Drop down list 1:
1
2
3

Drop Down list 2:
A
B
C

If I selected 2 from the fist list I would want list two to automatically
register B.

How do I create a dependent list, to a current list?
 

Try Deb's solution he
http://www.contextures.com/xlDataVal02.html
These are called "cascading" or "dependent" drop-downs. :)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"elevenphil" wrote in message
...
I am trying to create a dependent responing list to another drop down list
in
excel.

I.e.
Drop down list 1:
1
2
3

Drop Down list 2:
A
B
C

If I selected 2 from the fist list I would want list two to automatically
register B.