hi all-
I'm trying to create a cascading drop down list that has two initial fields before the final field option is given. All the examples I've seen online only deal with two total fields (example: http://www.contextures.com/xlDataVal13.html).
The data that I have includes Country, State and then City and the only way to get to the correct city is by selecting an appropriate country and state (with each choice narrowing the options). I don't think this is possible with data validation (although, I'm not sure).
Any help would be greatly appreciated as I don't really want to code this out with combo boxes.
thanks,
ghost
I'm trying to create a cascading drop down list that has two initial fields before the final field option is given. All the examples I've seen online only deal with two total fields (example: http://www.contextures.com/xlDataVal13.html).
The data that I have includes Country, State and then City and the only way to get to the correct city is by selecting an appropriate country and state (with each choice narrowing the options). I don't think this is possible with data validation (although, I'm not sure).
Any help would be greatly appreciated as I don't really want to code this out with combo boxes.
thanks,
ghost