Data Validation - Linked to each other

[michelle 1]

Hi

I have posted on here as i think this may require VBA code and i was hoping someone may be able to help.

I have a spreadsheet with various tabs. I have a validation in cell C2 and one on another tab in cell D2. I am trying to get them to work in conjuction so whichever selection is made from either both will showthe same result, i need them both to be validations though. Is this possible?

Michelle

[MickG]

You can do this by using Two "Worksheet_Change event" Codes:- One code in each sheet.
Place in sheet1, Sheet Code Module (This Sheet have "Validation list" in "D2"

Private Sub Worksheet_Change(ByVal Target As Range)
    If ActiveSheet.Name = "Sheet1" Then
        If Target.Address(0, 0) = "D2" Then
            Sheets("Sheet2").Range("C2").Value = Target.Value
        End If
    End If
End Sub

Place in sheet2, Sheet Code Module (This has Validation List in "C2")

Private Sub Worksheet_Change(ByVal Target As Range)
    If ActiveSheet.Name = "Sheet2" Then
        If Target.Address(0, 0) = "C2" Then
            Sheets("Sheet1").Range("D2") = Target.Value
        End If
    End If
End Sub

[michelle 1]

Dear MickG

You are a genius, thank you so much for replying it works perfectly.

Michelle

[MickG]

You're welcome