How to synchronize the choices on several identical drop down menus?

I have drop down menus (on several sheets), all offering the same list of choices, and I would like to synchronize them, i.e. if I change the choice on any of the drop down menus, also the choices on all the other drop down menus should change accordingly.

How do I do that?

Thanks for any suggestions!

Best,

Fridolin

Assign the values for your drop down menus to a seperate worksheet (hide if you don't want other to see it) then you can link your other menus to that sheet. Whenever you make a change to the values all your drop downs will change too since they all draw from the same location.

Originally Posted by Motu040602

Assign the values for your drop down menus to a seperate worksheet (hide if you don't want other to see it) then you can link your other menus to that sheet. Whenever you make a change to the values all your drop downs will change too since they all draw from the same location.

Thanks for your answer, Motu040602. It doesn't seem to do what I want, though. Here is another description of the situation:

• I have a drop down menu (values: Jan, Feb,…, Dez) on sheet 1
• I have a drop down menu (values: Jan, Feb,…, Dez) on sheet 2

And it should behave as follows:

• Imagine both drop down menus are initially set on Jan
• Now I go to sheet 1 and set the drop down menu on Dez
• If I now switch to sheet 2, I would like the drop down menu on sheet 2 automatically (!) be set on Dez as well

… and also the vice versa:

• Imagine I now set the drop down menu on sheet 2 (from Dez) to Feb
• If I now switch back to sheet 1, I would like the drop down menu on sheet 1 automatically (!) be set on Feb as well

Any ideas how to implement this?

Thanks,

Frido

The only way I can think of to do this is with a event change macro that copies and pastes the values from any changed drop down menu into the assigned cell for your other sheets. Or a macro that activates you drop down menus each time another one is changed. I don't know if macros are acceptable for you??? Also this is a complicated bit a VBA unless you are fairly adept.