New link

[flyfree]

I have two identical spreadsheets and when I update the first I want the
second to be updated also. (Step-by-step please, I haven't set up a link
before)

 

[Pete_UK]

Are these two sheets in the same workbook, or two separate workbooks?

Pete

 

[Luke M]

Copy everything you want linked on sheet 1 (I'll assume A1:Z100). Select
sheet 2. Select cell A1, right click, and choose "paste special". Click the
"paste link" button.

 

[flyfree]

Thank you - you're a star!

Copy everything you want linked on sheet 1 (I'll assume A1:Z100). Select
sheet 2. Select cell A1, right click, and choose "paste special". Click the
"paste link" button.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*