Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: multiple worksheets consolidated report

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Weathersfield,VT
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I would appreciate learning how to construct a formula or function that would allow me to create, on a summary worksheet, a SUM total of cell entries on 40 plus worksheets in the same workbook, which entries are all in identical positions on the sheets. So I'd like to retrieve and SUM, for example, all 40 cell B24s, into a cell on the summary sheet. The need arises since the 40 worksheets were originals produced without the now needed category as part of the summary sheet. I'd like to avoid having to do the tedious job of creating a new report column of all the needed data, by going back and forth, summary to individual sheets to create cell reference formulas. Thanks in advance for advice.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See the Excel Help topic for "Refer to the same cell or range on multiple sheets by using a 3-D reference".

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Weathersfield,VT
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mark, Thanks for the information. That does the job. I appreciate the quick help! Bob

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you can change little of your logic for what you are doing I think you can change lot of your time and energy.

    I had one question from friend like you and i have suggest him to use autofilter and then link the last cell to give you the results.

    Here you can even avoid using number of workseets... i think you can just use one main worksheet as data and then get customise reports.

    goto my site http://www.pexcel.com/guestdownload.htm

    here you can download file 'Daily Total'

    this is for some fire station.

    if you have any difficulty write back to me

    ni****h desai
    nisht@pexcel.com
    http://www.pexcel.com

  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    Weathersfield,VT
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the input. My worksheets, each pertaining to an individual employee, have quite a lot of data, with 12 or so different kinds of information on them, so don't seem to be small enough to have several on one sheet. But I'm happy to try other structures, since I am sure there are more efficient ways to do what I am trying to do. I am no expert at Excel, though definitely want to learn more. Regards, Bob

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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