As answered in microsoft.public.excel.misc:

If these are data validation dropdown lists, there are instructions here
for dependent lists:

http://www.contextures.com/xlDataVal02.html

gettin-older wrote:
Is there any way I can make the info thats input in one column (selected by
dropdown list) determine which (one of several) dropdown list is used in
another column?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html