New link
 

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)

New link
 

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

Pete

On Nov 9, 10:05*am, flyfree wrote:
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)

New link
 

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!*


"flyfree" wrote:

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)

New link
 

Thank you - you're a star!

"Luke M" wrote:

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!*


"flyfree" wrote:

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)