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