My spreadsheet has a validation list for each of the cells A3:A34. Cells G3:G34 have a validation list dependant on the input on the A3:A34 cells. For example, if you select "Materials" from the drop-down list in cell A3, the validation list for G3 is limited to only material codes. If you select "Labor" from the drop-down list in cell A4, the validation list for G4 is limited to only material codes.
The issue I'm having is that the user selects the data from the A3 cell, selects from the filtered list in the G3 cell, and then revises the A3 cell selection. The G3 cell does not reset and has incorrect data based on the original selection. How can I rest the dependant G3 cell back to blank if the A3 cell is changed?
Bookmarks