|I need help...|
Is there a way to create 2 seperate drop down lists for a single dependent? I have two columns that I need to have updated depending on what is selected in another cell.
In Cell A1 I have a drop down list (Asia, Europe, South America, North America, etc.)
In Cell B1 I have created a drop down list to reflect the different Languages spoken for what is selected in cell A1
In Cell C1 I would like to have the different types of currency for what is selected in A1.
Cell A1=Drop Down List (Select: Europe)
Cell B1=Selected Europe in Cell A1 (Drop Down list with choice of Czech, English, Greek, Hungarian, Polish, French, Spanish, etc)
Cell C1=Selected Europe in Cell A1 (Drop Down list with choice of US Dollars, Euro, Pounds, etc.)
For Cell B1 I created a list for every type and and named each list (name box) so it corelates to the selection. Spain, France, Italy, etc...and in the name box named the list Europe. Japan, China, Korea, etc...and in the name box named the list Asia...In the Data Validation in the Source code, I used the INDIRECT(A1) function...and that is as far as I got....need help setting up Cell C1 with a drop down dependent on what is selected in Cell A1.
I hope this makes sense. Any help is greatly appreciated.
Thanks in advance