Hello, I have 2 drop down type data validation options on my worksheet and I need one of them to be clear of any visible selections if the other drop down has a visible selection picked. Ideally the can both be blank or only one of them can have a visible selection at any given time; so depending on the drop down menu option one picks it will clear the other.
I was hoping for some help to do this primarily using a
type code if possible. Cell m6:P6 and cell M11:P11 have my drop down menu options.
Appreciate your time and help!
Bookmarks