I followed one of the online tutorials to create cascading dependent drop down list.
But this approach only allows me top-down data entry. Lets say I have to set geographical location. First I have to choose continent, then country, then county and then city (this is just simplified example). In order to speed up the process I would like to have the option to fill in the table from down to top: once I set the city excel automatically settles the higher hierarchy. The example above does not allow this option- I have to start from the higher classification.
I could not find the solution online or in these forums. Maybe I am usin wrong keywords. Your help is greatly appreciated.
Sergei