Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 3 of 3

Thread: Adding Cell Values From One Worksheet To Another Worksheet

  1. #1
    Join Date
    7th March 2006

    Adding Cell Values From One Worksheet To Another Worksheet

    I am working with several worksheets in a file. The first sheet is going to be a "grand total" sheet. I want to accumulate numeric data in cell B10 on all other sheets to a total in cell C14 on the "grand total" (first) sheet.
    Can anybody help? P L E A S E???

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    24th January 2003

    Re: Help: Adding Cell Values From One Worksheet To Another Worksheet

    Hi MrJay

    Welcome to ozgrid.

    Please read THIS PAGE IN FULL.

    You have use the superfluous word "Help" even though it states non the New Thread page not to. Please take more care in future.

    In regards to you question. In the cell on the Grand Total sheet type


    Then use your mouse pointer to select the the first sheet, then select the needed Cell(s). Finally hold down the Shift key and click the last sheet and you should end up with a SUM formula


  3. #3
    Join Date
    26th January 2003

    Re: Adding Cell Values From One Worksheet To Another Worksheet

    check these free examples, look at the Summary examole
    Hope that Helps


    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 1
    Last Post: June 12th, 2007, 01:32
  2. post cell values to worksheet
    By elrussell in forum Excel General
    Replies: 12
    Last Post: February 28th, 2006, 10:17
  3. Replies: 3
    Last Post: November 10th, 2004, 22:42
  4. Replies: 2
    Last Post: May 26th, 2004, 02:11
  5. List Box Problem - Saving Values in Worksheet Cell
    By George in forum Excel General
    Replies: 7
    Last Post: May 16th, 2003, 03:40


Posting Permissions

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