+ Reply to Thread
Results 1 to 3 of 3

how to carry balances from one worksheet to another

  1. #1
    silverdw
    Guest

    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

  2. #2
    Bernard Liengme
    Guest

    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" <[email protected]> wrote in message
    news:[email protected]...
    >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




  3. #3
    Marcelo
    Guest

    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
    >
    > Thanks for your help


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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