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
FOR SALE BRAND NEW UNLOCKED NOKIA E75
by rachy
29 minutes 48 seconds ago
FOR SALE BRAND NEW APPLE IPHONE 32GB 3GS
by rachy
36 minutes 3 seconds ago
Best setup for LAMP?
by Elder Usr
07/01/09 10:49 PM
OOo macro SQLException
by xtoph
06/28/09 12:06 PM
Decrease tooltip/infotip delay?
by firebo14
06/27/09 04:59 PM
Who's Online
1 Registered (rachy), 259 Guests and 32 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
90532 Members
24 Forums
52157 Topics
182376 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