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...




Topic Options
#182573 - 06/12/08 09:29 AM Excel Problems
McGuywer Offline
stranger

Registered: 11/15/07
Posts: 13
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


Edited by McGuywer (06/12/08 09:40 AM)

Top
Advertisement
#182652 - 06/13/08 05:32 PM Re: Excel Problems
Wilhelmus Offline
old hand

Registered: 12/21/04
Posts: 1024
Loc: Finland / Suomi
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.

Top
#186217 - 09/06/08 12:24 AM Re: Excel Problems
TheTool Offline
stranger

Registered: 09/06/08
Posts: 2
and make sure Automatic Calculation is turned on...

Top


Forums
Windows Support Forums
Everything New Technology
Legacy OS
Hardware
Software
Games
Networking
Customization & Tweaking
Security

Linux Support Forums
Everything Linux
Linux Hardware
Linux Software
Linux Games
Linux Networking
Linux Customization & Tweaking
Linux Security

Apple Support Forums
Everything Apple
Recent Topics
Ntloader missing message when trying to install xp
by Complutenovice
Yesterday at 04:20 AM
Odd 3DO malfuction.
by one thread wonder
07/09/09 06:53 AM
DosBox v0.73 Released
by jmmijo
07/09/09 04:20 AM
qtech winxp pc
by johnmony
07/08/09 12:58 AM
Best setup for LAMP?
by Elder Usr
07/01/09 10:49 PM
Who's Online
1 Registered (Philipp), 130 Guests and 17 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
90552 Members
24 Forums
52386 Topics
182617 Posts

Max Online: 1079 @ 03/12/08 01:36 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22