Linking a worksheet from a different excel file

T

Trever B

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
 
P

penri0_0

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
 
Top