Paste a sheet as a link
you can link at the cell level.
Select your range, go to the new location, do Edit=Paste Special and select
the paste link button.
Turn on the macro recorder while you do it if you want to get code
--
Regards,
Tom Ogilvy
Yakimo wrote in message
...
Happy New Year!
Is there any way to have a link to a sheet? I mean to copy a sheet from
one
workbook to another workbook as a link, so when I change the book in the
source worksheet and after open the destination book, the sheet changes to
be populated.
Thanks,
Yakimo
|