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
 
You must log in or register to reply here.

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
Log Sheet 1
Attempted edit of protected cell jumps user to another cell 2
Macro to email to address in cell reference 1

Back
Top