ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking a worksheet from a different excel file (https://www.excelbanter.com/excel-discussion-misc-queries/88032-linking-worksheet-different-excel-file.html)

Trever B

Linking a worksheet from a different excel file
 
Hi,

Thanks in advance

Have a Summary worksheet in File A which are made up from worksheet also in
file A.

What I need is a copy of the summary in excel file B (With all links in tact)

Is there a quick way to do it or do I have to reference each one.

Trev

penri0_0

Linking a worksheet from a different excel file
 

You should be able to by highlighting the cells you wish to copy, and
then Paste Link from the Paste Special menu in your new workbook.

Hope this helps


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=541004



All times are GMT +1. The time now is 07:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com