• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

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
0
sydneyguy
Asked:
sydneyguy
3 Solutions
 
barry houdiniCommented:
This might help
post back if you can't make it work
regards, barry
0
 
TracyVBA 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
 
patrickabCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now