sht 1 cell a to track contents sh 2 cell n

  • Thread starter Thread starter nick
  • Start date Start date
N

nick

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.
 
Try this formula on sheet 1 or any other sheet to mirror what is in a1 of
Sheet 2

=Sheet2!A1

Mike
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
Excel Import Comments 3
Copy Sheet to new Sheet and clear cells on original sheets 7
Sharing workbooks limitations - Merged Cells 12
Use different cell content as headers 3
Macro to email to address in cell reference 1
Log Sheet 1
Attempted edit of protected cell jumps user to another cell 2

Back
Top