Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dependant lists- trigger a blank when 1st one is changed?
Hello:
I currently have two columns: Column A is Countries Column B is Cities associated with those countries in Column A I have the data validation set up so that when you select Australia, for example, in Column A, it limits/narrows the drop down list in Column B to only show choices of cities in Australia (Sydney, Brisbane, etc.). Here's my problem: when I have already selected the Country and city (Australia and Sydney for example) and then later decide to change the Country choice, it still shows the old city that I chose for Australia. So, I may change the country to Japan, but it will still show Sydney in Column B unless I click on the Column B drop down. In order to avoid careless mistakes, I would like to have it automatically trigger the Column B to go blank if Column A is changed. Thus prompting the person to know that they have to fill a choice in for city from the Column B drop down. Is this possible? Much thanks!! JR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependant lists help needed | Excel Discussion (Misc queries) | |||
Dependant Lists Question | Excel Worksheet Functions | |||
3 way dependant lists | Excel Worksheet Functions | |||
Dependant Lists in Excel | Excel Worksheet Functions | |||
Dependant Lists | Excel Discussion (Misc queries) |