I'm making a template, which would ideally have three sheets:
Sheet 1, where the user pastes her data sheet
Sheet 2, where formulas are used to generate more data based on the pasted data from sheet 1 (protected against changes so users don't accidentally mess with the formulas)
Sheet 3, where all data from sheet 2 is pasted as values so the user can easily see the data and use filters to manipulate it (not protected against changes)
How do I make sheet 3? Is it possible to have everything in sheet 2 pasted as values in sheet 3 as part of the template setup so the user does not have to copy and paste to a new sheet? If so, how? Many thanks in advance for your help!
2. Sheet 2: Formulas generate data from Sheet 1. Protect it to prevent accidental changes: - Select cells > right-click > Format Cells > Protection > Uncheck "Locked." - Protect the sheet (Review > Protect Sheet). Protect a worksheet - Microsoft Support