A real worksheet template
I create a lot of workbooks with a repetitive worksheet. For example, a workbook would contain multiple sheets representing a particular day for a project, with the workbook representing the project.
Each of these worksheets have exactly the same formulas and layout, so I create a 'template' worksheet in the workbook, which is then copied to create each of the worksheets.
If I want to change the template, I have to go through each of the copies to manually alter the formulas.
What would be cool is:
- Create a worksheet as a template
- Reference that template in copies (Copy from template?)
- Whenever I change the 'master' template worksheet, all the others change as well.