Thread: How can I make spreadsheet content link to another sheet and have.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How can I make spreadsheet content link to another sheet and have.
See help on "linking"

Basics.............on sheet2 enter =sheet1!A1

Copy across and down.

OR.......select a range on sheet1 and copy.

Switch to sheet2, select a cell and EditPaste SpecialPaste LinkOKEsc.


Gord Dibben MS Excel MVP

On Thu, 28 Aug 2008 07:31:01 -0700, Hyperlinking Spreadsheets <Hyperlinking
wrote:

the content automatically update?

Reply With QuoteReply With Quote