Forum Discussion
Not typical copy and paste questions
Is there a way to have a spreadsheet, that is set up already with formulas and some cells protected, and then when I copy to a new page, it transfers the data, clears the unprotected cells and carrie...
Could you simply copy the worksheet?
Note: If you use defined names (I never reference data other than by name), then it is best to use names scoped to the sheet.