if one drop down has a selection then the other drop down will be cleared

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

Please Login or Register  to view this content.

type code if possible. Cell m6:P6 and cell M11:P11 have my drop down menu options.

Appreciate your time and help!

I think a list box or a combo box might be a better solution, but if you really want a drop down list you could do it with this code and variable length named ranges.

Please Login or Register  to view this content.