Hi there
I am using the following code in a sheet called "Centre"
Code
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
Display More
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.
Thanks