Having created primary and secondary validation drop downs, the issue is that when a primary validation cell changes, the value in the secondary validation cell does not become blank (or change automatically to first entry of the secondary validation list). Instead the secondary validation cell remains the same as what was already selected earlier.
In the this workbook, i present the following three cases of dealing with the secondary validation cell value when the primary validation cell changes:
1. The moment the primary validation entry changes, blank out the secondary validation cell
2. The moment the primary validation entry changes, show the corresponding first entry of the secondary validation drop down
3. The moment the primary validation entry changes, perform the following:
a. If there is only one corresponding entry in the secondary validation drop down, then show that entry (no need to select); and
b. If there are multiple corresponding entries in the secondary validation drop down, then blank out the secondary validation cell
Secondary validation cell entry to update when primary validation cell changes
{ 30 Comments }