How to Reset Dependant Validation Data?

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?

Originally Posted by alansidman

Look at this tutorial and see if your set is the same or if you are missing something

http://mauriceausum.wordpress.com/20...oxes-in-excel/

Thanks, but the provided link only gives you instruction on how to setup a dependant validation list. It does not address my specific issue.

Attached is a simplified sample excel sheet that illustrates the issue.

Originally Posted by alansidman

Running out for some exercise. Will check back in a couple of hours. If no one has helped by then, I will see what I can do. I am confident that it can be fixed.

Alan

Thanks for trying to help out. I do appreciate it.