VBA to auto clear multiple drop downs in single sheet

Hello,

Hoping you can help.


I have a sheet with five tables, each table has two drop downs that the formula depends upon. However, for the formulas to work correctly, criteria is only needed in one of the drop down menus, and the other menu should remain blank.

I would like to be able to select an option from either drop down and for the other drop down menu to clear. So if C6 = selected, C5 = clear and vice versa. I then need this across all 5 tables, and each table and set of drop downs being treated independently.

I have found a code that allows it to work one way on one of the tables, but not the other way.

(To clarify by table, I do not mean an excel table. It is just a normal grid made up of formula, if that makes any difference)

Good morning,

Apologies for the delay in getting back to you. I was at a conference yesterday and unable to try this out. This worked perfectly! Thank you so much for this, really appreciated!