• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy static worksheet into weekly worksheets

M

msfraser302

New Member
I have a workbook with worksheets for each week of the year. Each weekly worksheet has some static data that I keep having to update from week to week (if it changes). I would like to put this static range of cells into its own worksheet and have it linked to each weekly worksheet. If I update the static data it would be automatically updated in the weekly worksheets.


I tried using paste link, which works but it doesn't copy the formatting, just the cell data. I need the formatting as well. I tried a paste link picture but that isn't exactly what I want.


Any help would be appreciated.


Thanks,

msfraser302
 
If your data is in Cell D10 on your Static Sheet

then you simply use


on the weekly sheets

=StaticSheetName!D10


If the StaticSheetName has spaces like Static Sheet Name

use

='Static Sheet Name'!D10
 
enter into A1 on your weekly sheet

=StaticSheetName!A1


then copy this from A1 to A1:R42
 
You must log in or register to reply here.
Back
Top