Linking Dropdowns in different sheets

[timsvo]

Dear all,

I have two sheets with data that can be changed through a scenario selection in a dropdown on sheet1. I would now like to create a second dropdown on sheet2 that is identical to dropdown 1 in such a way that if I change either one, the other changes with it.

I assumed I would need to use VBA, which I tried but it didnt work. Is such a thing possible and if so, how?

Thank you very much in advance!

Tim

 

[timsvo]

Both dropdowns are by the way located in cell B10 of the two sheets