Thread: sht 1 cell a to track contents sh 2 cell n
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default sht 1 cell a to track contents sh 2 cell n
What do you mean by "track the contents"?

You can enter =Sheet2!cellref into a cell on Sheet1 and as you change the
source cell contents, the destination cell will change to match.


Gord Dibben MS Excel MVP

On Tue, 5 Aug 2008 10:57:00 -0700, nick
wrote:

I would like for a cell in sheet 1 of a workbook to track the contents of a
single cell on sheet 2 of the same workbook.

Reply With QuoteReply With Quote