Excel Problems

[McGuywer 0]

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

[Wilhelmus 1]

Originally Posted By: McGuywer

Hi,

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

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

Quote:

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

Create and manage links to other workbooks.

[TheTool 0]

and make sure Automatic Calculation is turned on...