I am trying to copy balances from one worksheet to another over a total of 12
worsheets ..... this is for petty cash monthly sheets and I need a running
total over the 12 sheets.

At present I have to do this manually .... is there a formula that I can use
that will automatically carry the balances over

Thanks for your help

hi,

on the sheet2 use

=(sheet1!g100)

assuming that the final balance on the sheet 1 is on G100 cel.

hth
regards from Brazil
Marcelo

"silverdw" escreveu:

I am trying to copy balances from one worksheet to another over a total of 12
worsheets ..... this is for petty cash monthly sheets and I need a running
total over the 12 sheets.

At present I have to do this manually .... is there a formula that I can use
that will automatically carry the balances over

Thanks for your help

On Sheet1 in cell C20 I have the value $200.50
On Sheet2, in cell D5 I have =Sheet1!C20 and it displays the $200.50 from
sheet1.
Is this what is wanted?
If the sheet name has spaces it you need, for example, ='Jan Cash'!C20
Best way to make the formula is:
type =
point and click on the cell in second sheet
click green check mark in Formula Bar or hit ENTER key
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"silverdw" wrote in message
...
I am trying to copy balances from one worksheet to another over a total of
12
worsheets ..... this is for petty cash monthly sheets and I need a running
total over the 12 sheets.

At present I have to do this manually .... is there a formula that I can
use
that will automatically carry the balances over

Thanks for your help