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.

Windows Software 5498 This topic was started by ,


data/avatar/default/avatar12.webp

13 Posts
Location -
Joined 2007-11-15
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

Participate on our website and join the conversation

You have already an account on our website? Use the link below to login.
Login
Create a new user account. Registration is free and takes only a few seconds.
Register
This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic


data/avatar/default/avatar09.webp

1019 Posts
Location -
Joined 2004-12-21
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.

data/avatar/default/avatar08.webp

2 Posts
Location -
Joined 2008-09-06
and make sure Automatic Calculation is turned on...