I have attached a copy of the spreadsheet. The values in sheet2 cells A1 and C1:C6 will change but I need the values in sheet1 cells C2,E2,G2,I2,K2 and M2 to remain after the changes in sheet2. Is there a way to do this using IF statement or do I need to do it another way?
Bookmarks