- Joined
- Oct 23, 2009
- Messages
- 1
- Reaction score
- 0
Hi
I've a requirement as there should be 3 columns "Area", "location", "city".
Where in location lists based on area and city lists based on area and country combination.
e.g.
Area location City
India Karnataka Bangalore
India Karnataka Mysore
USA California California
When india is chosen from area list, location should list only karnataka and city should list bangalore and mysore.
Data validation has been implemented but since i've more than 300 such combinations can't maintain data validation for all area,location combination.
Is there a way in excel or vba to fill this requirement?
I've a requirement as there should be 3 columns "Area", "location", "city".
Where in location lists based on area and city lists based on area and country combination.
e.g.
Area location City
India Karnataka Bangalore
India Karnataka Mysore
USA California California
When india is chosen from area list, location should list only karnataka and city should list bangalore and mysore.
Data validation has been implemented but since i've more than 300 such combinations can't maintain data validation for all area,location combination.
Is there a way in excel or vba to fill this requirement?