Linking drop down menus on two separate tabs

macabre100

New Member
Joined
Mar 25, 2005
Messages
29
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!!!
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
You can do this with event handler macros.

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

Code:
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,327
Messages
5,571,560
Members
412,405
Latest member
DutchMonkey
Top