I am using the following code in a sheet called "Centre"
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.