I have a spreadsheet that contains a summary of information about our clients.
There is a sheet that is the "Template". As new clients are added we copy the template and paste it as a copy in that workbook, rename it, and add in the client data.
What I am wondering is if there is a way that if we modify the template that it will carry over into all the copied sheets (client sheets)
For example:
1. add a row or column
2. Change fonts, color, or text size
3. change a formula value
can a spreadsheet be created that all this information on every sheet is based on the template sheet.
I would like to be able to do this so we can make changes to only one sheet when it comes to adding new cells or reformating and then it will replicate those changes to the 15-20 other sheets.
Bookmarks