So I have hit a brick wall with my project I am working on in Excel. Here is my scenario for example I have a worksheet with a list of 17 questions with answers based on a validation list. My client would like to have the answers copied over to Sheet2 which is not a big deal however they want the answers copied over and the ability to do an override on Sheet 2. I have tried several ways but no success. I am able to build the validation list and copy the values sure but I was using the Worksheet activate and everytime I leave the sheet and back again I get the copied value over I have tried just doing a =Sheet1:A1 type of thing which sort of worked but in also increase the file size. I am not even sure it is possible withot a button to override. Any suggestions would be appreciated.