# how to carry balances from one worksheet to another

1. ## 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

2. ## Re: 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" <silverdw@discussions.microsoft.com> wrote in message
news:0661E81A-0B5C-4156-B05A-6B9B0AA5871B@microsoft.com...
>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
>

3. ## RE: 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
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1