| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.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? |
|
#2
Posted to microsoft.public.excel.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 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel auto-direct you to the source of a link? | Excel Discussion (Misc queries) | |||
| 2003 update link when Source open | Excel Worksheet Functions | |||
| Link - deactivate being sent to source when click on linked cell? | Excel Worksheet Functions | |||
| How do I break a link to a source when opening Excel 2000? | Excel Worksheet Functions | |||
| Unable ot Break link for Macro with no source | Excel Discussion (Misc queries) | |||
Linear Mode
