Linking drop down menus on two separate tabs

[macabre100]

I use Data-Validation-list to create drop down menus. I want to create the same drop down menu in two tabs and link them together. In other words, the user should be able to change the menu on one tab and the other tab automatically updates and vice versa.

Any ideas???

Thanks in advance!!!

 

[Oaktree]

You can do this with event handler macros.

Right click on your sheet tab, go to view code, and paste:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then Sheets("Sheet2").Range("A1") = Target
End Sub

This will cause Sheet2!A1 to change to whatever you just made $A$1 on the current sheet.

I'm guessing that you'd want a similar event handler for sheet2 as well.