Drop-Down List

[Jarod]

How do I select from a drop-down list, and have a second drop-down list
change based on my selection of the first drop-down list.

 

[FSt1]

hi
see this site....
http://www.contextures.com/xlDataVal02.html

regards
FSt1

 

[grizzly6969]

there are several ways to do this - - one way is say your drop down is A1 and
your choices are Canada / USA. were ever you make a list for your second
dropdown list = Ontario / Alberta / Quebec etc. in the define name range call
this column Canada - - your next list = Florida / Main / Texas etc. in the
define name range call this USA
in cell B1 type in =indirect(A1)

 

[grizzly6969]

I'm sorry I got a little finger happy ---- in cell B2 go to data validation
and in ALLOW go to list and in SOURCE type in =indirect(A1)