anglais428
Well-known Member
- Joined
- Nov 23, 2009
- Messages
- 634
- Office Version
- 2016
- Platform
- Windows
Hi,
I am trying to use the data validation to come up with 2 dropdowns (list boxes) with one depending on the other. I have a list of countries (72 locations say Argentina to Vietnam). I want these to appear in the first dropdown in A1 - I can do this (using list box). I then want (in A2) another dropdown that depends on which country is chosen in A1. e.g. If Argentina is selected in A1 only Buenos Aires should be available in the dropdown in A2.
I have a list of Countries and Cities side by side e.g. Argentina (cell E1) and Buenos Aires (cell F1). The range of this is E1:F289
Any help linking the second dropdown to the first would be great.
THanks,
I am trying to use the data validation to come up with 2 dropdowns (list boxes) with one depending on the other. I have a list of countries (72 locations say Argentina to Vietnam). I want these to appear in the first dropdown in A1 - I can do this (using list box). I then want (in A2) another dropdown that depends on which country is chosen in A1. e.g. If Argentina is selected in A1 only Buenos Aires should be available in the dropdown in A2.
I have a list of Countries and Cities side by side e.g. Argentina (cell E1) and Buenos Aires (cell F1). The range of this is E1:F289
Any help linking the second dropdown to the first would be great.
THanks,