Copying entire spreadsheet, but cell values link to original spreadsheet

[gingerbug]

Hi everyone,

I have a fairly large, but fairly simple spreadsheet which is used as a budget. I want to be able to create a copy of that spreadsheet, but instead of the cell values being the same, they're actually all ='Originalworkbook'!A1, for example.

I want to do this because I want to manipulate the data in the first workbook and have it change automatically in the second. Does anyone know how to do this?

Thanks in advance!

 

[Jimmypop]

Hi there

Maybe something like below... You would just need to update your sheet names and ranges... let us know if this works?

Sub Copy_Paste_Link()
    Worksheets("Sample Data").Range("B5:M107").Copy
    Worksheets("Example 5 - Paste Link").Activate
    ActiveSheet.Range("B5").Select
    ActiveSheet.Paste _
    Link:=True
    Worksheets("Example 5 - Paste Link").Columns("B:M").AutoFit
End Sub