Dropdown menus on separate sheets mirroring each other

[mark9988]

Hello,

I have identical dropdown validation menus on 4 separate sheets. I would like for them to mirror each other, so that:

If I select "Hot" from the dropdown in sheet 1, it then it automatically changes to "Hot" across the dropdowns in remaining sheets (sheet 2, 3, 4).

or

If I select "Cold" from the dropdown in sheet 3, it then it automatically changes to "Cold" across the dropdowns in remaining sheets (sheet 1,2,4).


Best,
Mark9988

 

[mark9988]

Below is my script allowing for one validation box on each sheet:

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified 2/16/2022 5:31:14 PM EST
If Target.Address = "$C$4" Then
Application.EnableEvents = False
Sheets(1).Range("C4").Value = Target.Value
Sheets(2).Range("G3").Value = Target.Value
Sheets(3).Range("A1").Value = Target.Value
Sheets(4).Range("A1").Value = Target.Value
Application.EnableEvents = True
End If
End Sub


As I attempted to add two validation boxes to sheet(1), I tried this but no luck:

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified 2/16/2022 5:31:14 PM EST
If Target.Address = "$C$4" Then
If Target.Address = "$C$5" Then
Application.EnableEvents = False
Sheets(1).Range("C4").Value = Target.Value
Sheets(1).Range("C5").Value = Target.Value
Sheets(2).Range("G3").Value = Target.Value
Sheets(3).Range("A1").Value = Target.Value
Sheets(4).Range("A1").Value = Target.Value
Application.EnableEvents = True
End If
End Sub