Link two drop down list with each other

Hi, all,

I have one drop down list in cell A1 and another in cell C1 with the same data. When I select something in A1 I want it to change in C1 also and the other way around. Is this actually possible?

In advance many thanks in advance.

Jairo

Hi,

this is possible, all you need to do is put the code below in the sheet module in the vba editor:

Please Login or Register  to view this content.

I have attached a workbook for your reference. You need to enable macros in order for it to work...

Let me know if this is what you need.

Thanks.