Worksheet_Change Event

    Hi there


    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.


    Thanks

    Re: Worksheet_Change Event


    Late to the party and on days off so no access to excel....but :) looking at your code and keen to learn,


    Would it have worked if you had changed your original code to:


    Code
    1. if target = Range("D2") then


    * untested, just interested :)