Drop-Down List

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.
 
G

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)
 
G

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top