View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
supoch14 supoch14 is offline
external usenet poster
 
Posts: 25
Default How can I make spreadsheet content link to another sheet and h



"Gord Dibben" wrote:

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?