sht 1 cell a to track contents sh 2 cell n
 

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.

sht 1 cell a to track contents sh 2 cell n
 

Try this formula on sheet 1 or any other sheet to mirror what is in a1 of
Sheet 2

=Sheet2!A1

Mike


"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.

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.