how to carry balances from one worksheet to another
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 |
how to carry balances from one worksheet to another
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 |
how to carry balances from one worksheet to another
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 |
All times are GMT +1. The time now is 01:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com