Drop-Down List

  • Thread starter Thread starter Jarod
  • Start date Start date
J

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.
 
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)
 
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)
 
Back
Top