Updating cells on different worksheets

  • Thread starter Thread starter Martin Murray
  • Start date Start date
M

Martin Murray

Hi All

If I enter a value on one worksheet how do I get it to automatically update
a cell on another worksheet?

Thanks

Martin
 
if you enter a value in Sheet1, A1 and you want Sheet2 A1 updated with the
same value...

in A1 of Sheet2 enter the following

=Sheet1!A1
 
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

Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
refresh? 2
Excel VBA 1
Syschronizing cells across worksheets 1
Absolute References and worksheets 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top