help with formulas between worksheets

G

garethryanevans

first time on here....i'd really appreciate some help.....on worksheet 1 you
have a formula in one cell (call it cell A) which is a like a running total
of numbers, like earnings per week, and then you have a cell (call it cell B)
in sheet 2 which you want this figure to contain, and also update itself on
any additional earnings which increases the total of cell A. How can I get
cell B in sheet 2 to update itself when i'm working on sheet 1?
 
I

icestationzbra

if you have your sum on sheet1 in cell A10, and you want it on sheet2 i
cell A1, then place this formula in A1 on sheet2.

=Sheet1!A1
 
B

Bob Phillips

Cell B: = Sheet1!A1
where A1 is cell A

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
D

Don

Hi

Assume you have data in Cell A1, Sheet1
In Cell B1, Sheet2 (or whatever cell you want) insert this:

=Sheet1!A1

Sheet2 will update as you work or your formulas work on
Sheet1.

HTH,

Don
 
Top