+ Reply to Thread
Results 1 to 2 of 2

Template sheet changes carry over into copied sheets

  1. #1
    Forum Contributor
    Join Date
    01-05-2006
    Posts
    113

    Can changes to a Template sheet be set to carry over into copied sheets?

    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.
    Last edited by jermsalerms; 02-01-2007 at 05:23 PM. Reason: clarity in titile

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    IT depends very much on the change you want to make.

    If its a very specific change, then you could set up a macro triggered by the change on the template sheet to do the same to the other sheets.

    If its a more general set of changes, you could record a macro while making the changes to your template and rerun this macro on the others. You could even put the recorded macro inside a loop to make the job easier if you had lots of sheets.
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1