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
How to Transfer SMS/Contacts for Windows Mobile Ph
by StongZ
Today at 01:54 AM
Carmageddon 2 weird
by Kuikie
12/29/09 04:32 PM
Computer Repair Utility Kit
by gailerl
12/28/09 01:26 PM
x86 OS, RAM, & Virtual Machines
by Myke
12/22/09 08:16 PM
Ram Question
by JohnnyAshes
12/21/09 09:50 PM
Who's Online
2 Registered (danleff, fantaoyan1), 152 Guests and 33 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
91429 Members
24 Forums
59388 Topics
189922 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