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: 1025
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
Router keeps disconnecting internet
by rfboyd
Yesterday at 04:18 PM
Program Running When Starting Computer
by cbk
12/05/09 11:05 AM
System Crashing Error 1000008e, 1000000a, 0000004e
by PapaPrem
11/30/09 06:01 PM
Starcraft Broodwar Campaign Crash Problem
by Lurker02
11/30/09 12:33 PM
How do I affect the order of ALT-Tab?
by KenJackson
11/28/09 10:10 PM
Who's Online
0 Registered (), 254 Guests and 33 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
91271 Members
24 Forums
58408 Topics
188905 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