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