How do i link an entire source wksheet to a dest' wksheet

[Guest]

I want to produce a single worksheet clone copy destination file from a
source workbook.
I want any changes in the source worksheet to update the destination
worksheet.
This has a different name
I have tried insert object and insert hyperlink but to no acceptable end.
Paste link will only deal with individual cells and is too compicated
is there a simple way to creat a copy ant the end of each sessionon the
source file to back up the destination file?

 

[Gord Dibben]

Your statement "Paste link will only deal with individual cells" is incorrect.

Select the source sheet range of data and Copy.

Select a single cell in target sheet and Paste Special>Paste Link.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks that has worked it out for me.

Your statement "Paste link will only deal with individual cells" is incorrect.

Select the source sheet range of data and Copy.

Select a single cell in target sheet and Paste Special>Paste Link.


Gord Dibben MS Excel MVP