Excel Problems
This is a discussion about Excel Problems in the Windows Software category; 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.
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
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
Participate in our website and join the conversation
This subject has been archived. New comments and votes cannot be submitted.
Jun 12
Sep 6
0
1 minute
Responses to this topic
Originally Posted By: McGuywerHi,
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.
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.
and make sure Automatic Calculation is turned on...
