cascading drop down lists for excel

Have a spred sheet that i need to incorperate cascding drop down lists were as the example on the attached sheet, when you select the USA the next drop down or list box shows the capitals of the USA like wise UK then english counties and if Aust selected then the states of australia
am troling around the net any help would be appreciated dropdownlist.xls
sydneyguyAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
This might help
post back if you can't make it work
regards, barry
0
 
TracyConnect With a Mentor VBA DeveloperCommented:
Try this, it uses data validation for the dependency.  It's also has a dynamic range, so you can add as many values you want to each of the 4 columns on the Lists sheet.

dropdownlist.xls
0
 
patrickabConnect With a Mentor Commented:
sydneyguy,

Perhaps something like the attached file might be what you're looking for. It has three stages of dependant dropdowns.

Patrick
dependant-dropdowns02.xls
0
 
sydneyguyAuthor Commented:
thanks for the all your help works just fine
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.