Link two drop down list with each other

[javresistance]

Hi, all,

I have one drop down list in cell A1 and another in cell C1 with the same data. When I select something in A1 I want it to change in C1 also and the other way around. Is this actually possible?

In advance many thanks in advance.

Jairo

[Jarko28]

Hi,

this is possible, all you need to do is put the code below in the sheet module in the vba editor:

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

I have attached a workbook for your reference. You need to enable macros in order for it to work...

Let me know if this is what you need.

Thanks.

[:) Sixthsense :)]

Do right click on the sheet tab and select View Code and paste the below code. Return to excel and check.

Private Sub Worksheet_Change(ByVal Target As Range)

If Intersect(Target, Range("A1,C1")) Is Nothing Then Exit Sub

Application.EnableEvents = False

If Target.Column = 1 Then
    Range("C1").Value = Target.Value
Else
    Range("A1").Value = Target.Value
End If

Application.EnableEvents = True

End Sub