View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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