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