Results 1 to 2 of 2

Template sheet changes carry over into copied sheets

Threaded View

  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

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