Link 3 drop down lists

[Tpleme]

Hello guys, this is my very first time posting on this forum.

I really hope u can help me.

The thing is that i got 3 drop down lists in 3 different sheets (1 each), and this lists are exactly the same, what i was wondering was. It is possible to select an item in one of those 3 dropdown list and the other 2 change to the same value aswell.

Thank you in advance..
reagards

[BadlySpelledBuoy]

One way would be to use a change event on each sheet.
The code below would be for Sheet1 and will change the value in cell B2 on Sheet2 and Sheet3.

Please Login or Register  to view this content.

See attached.

BSB

[Tpleme]

that was really what i wanted,

thank you.:D

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.