worksheet functions >> 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?
worksheet functions >> 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 Special>Paste Link.
Gord Dibben MS Excel MVP
>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?
worksheet functions >> How do i link an entire source wksheet to a dest' wksheet
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
>
>
> >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?
>
>