Forum Discussion
Copy values from protected cells
I like to copy calculated values from a protected sheet to a unprotected sheet. How do i set this up?
If you can select the cells in the protected sheet, you can just COPY them and PASTE the into an unprotected sheet (or PASTE VALUES if you don't want to copy the formulae and formats as well).
If the person who protected the sheet such that cells may not be selected, you may want to reference to the cells you want to copy by entering e.g. =Sheet1!A1 (where "Sheet1" is the name of the protected sheet) in the unprotected sheet.