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.