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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Thanks that has worked it out for me.

Gord Dibben said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel-how to link source workbook to copy of destination workbook 1
Link cell between WS w/o dest display 0-jan if no entry at source 1
How can I insert a row in a source that links to a destination 1
External workbook links don't update when source file changes 1
Multiple "source" workbooks linked to single "destination" workboo 1
External Links in Excel 2007 with variable source file 5
Linked cells limited to ~253 characters unless source file open 3
Run time error 1004 Applicatin-defined or object-defined error (Copy from src to dest 1

Back
Top