Thread: How do I link multiple cells from another workbook?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I link multiple cells from another workbook?
Copy a range from source workbook.

Switch to destination workbook.

Select a single cell and EditPaste SpecialPaste LinksOKEsc


Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 09:50:49 -0700, Deb T <Deb
wrote:

How do I link multiple cells at the same time, between the source workbook
and the destination workbook? When I select multiple cells at a time, it only
links the first cell in the range.

Reply With QuoteReply With Quote