Excel Problems

Hi,

I want to change a value in one sheet and then update it automatically on another sheet. How can I do this?


And....

Can I change a value in one workbook and let it update automatically in another workbook?

Thanx in advance

Use formula:
=Sheet1!C5
(replace Sheet1 with your sheet name and C5 with your cell)



Create and manage links to other workbooks.

and make sure Automatic Calculation is turned on...