Excel Data validation for dependent list, VBA/EXCEL

V

vijayalakshmi.handi

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?
 

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

Similar Threads

Advanced Vlookup 1
stumped on creating dependent data validation lists 1
Excel 2010/2007 - How much can be done with Custom Validation? 6
Excel VBA Excel Macro to call drop down Validation List 12
Data Validation - Multiple Dependent Lists 4
Dependent list in excel to create validation 1
data Validation Dependent List Error 2
data validation list 17

Top