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

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?

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

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 SpecialPaste Link.


Gord Dibben MS Excel MVP

On Fri, 4 Aug 2006 09:04:02 -0700, tazzer
wrote:

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?

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

Thanks that has worked it out for me.

"Gord Dibben" wrote:

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 SpecialPaste Link.


Gord Dibben MS Excel MVP

On Fri, 4 Aug 2006 09:04:02 -0700, tazzer
wrote:

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?