ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Updating cells on different worksheets (https://www.excelbanter.com/excel-worksheet-functions/183812-updating-cells-different-worksheets.html)

Martin Murray

Updating cells on different worksheets
 
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


Gaurav[_2_]

Updating cells on different worksheets
 
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



"Martin Murray" wrote in message
...
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





All times are GMT +1. The time now is 04:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com