Good morning,

I have a sheet with 2 drop down lists using data validation, the second list will populate based on the value chosen in the first. My question is, when changing the independent list, the value in the dependent list remains the same. Is there any way to have the dependent value clear upon choosing a new value in the independent list?

Thanks in advance,
Chris