Reset dependant validation list when preceeding validation list is changed

[bujaman]

I have two validation lists working great, list 2 dynamically changes depending on the value selected in list 1. However, when you change the value of list 1, the old value for list 2 still shows. I would like list 2 to reset or clear when list 1 is changed. Can this be done?

 

[DonkeyOte]

You can not "clear" the 2nd DV list without VBA I'm afraid - you would need to apply some Change Event code such that cells to the right (within range of interest) are cleared when any given cell to the left is altered.

If you need more specific help please provide more detail - ie range references - are you applying the validation to multiple rows etc... - if so - do you wish to prevent simultaneous cell updates etc...