Keep an archive copy of the sheet
Duplicate the sheet as “Archive” at the end of the workbook, so you keep a snapshot before making changes.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Duplicate the sheet as “Archive”
Use it in MacroRoni: open the Starter gallery, search for "Keep an archive copy of the sheet", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More sheets & safety macros
Sheets & safetySave a backup copySave a dated copy of the workbook before you make big changes.Doesn't change valuesSheets & safetyFormat every sheet the sameStyle the header, freeze the top row and fit columns on every sheet in the workbook.Doesn't change valuesSheets & safetyLock the finished sheetAsk first, then replace formulas with their results and protect the sheet from edits.Changes data · backup on