I am using the following code in a sheet called "Centre"
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target = ("D2") Then Sheets("Consolidated").Activate Range("D2").Activate ActiveCell.Value = Sheets("Centre").Range("D2").Value End If End Sub
This code does not do what I thought it would, (Change the "Consolidated" sheet to that of the "Centre" sheet)
Cell D2 has a LIST Data Validation, and the idea is that the corresponding cell in sheets "CONSOLIDATED" also says the same as Centre!D2.
I know I could use a simple = in the consolidated sheet, but Consolidated!D2 also has a Data Validation of List.
I need the Consolidated to be the same as Centre, but with the option to change.
Hope that makes sense and someone can show me the error.