Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Apr 2015
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Linking spreadsheets to calculate totals

    I have a monthly report system that includes a separate spreadsheet file for each employee. There are 12 separate sheets (tabs), one for each month. Each sheet is the same format and has places to list totals as well as place to list class names, dates and # attendees instructed. I would like to be able to have a master spreadsheet that pulls in all of the information from 5 different employees (separate files) to populate totals for each month. Can someone assist me with the process or formulas that I would use for this?

  2. #2
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    My suggestion is to have ONE file with 5 tabs with all dates on one tab where you can filter for the months. Then just use sumproduct on the master sheet.
    Or, ONE file with ONE tab and all data and use filter with SUBTOTAL at the top for the filtered data

    Attach your file(s) and I'll show you.
    Don Guillett
    Excel Developer
    dguillett @gmail.com

  3. #3
    New Lounger
    Join Date
    Apr 2015
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    OK, I have attached the 2 files. I will ultimately have 5 different Advisor files that will need to feed into the Master Advisor file.

    Quote Originally Posted by Supershoe View Post
    My suggestion is to have ONE file with 5 tabs with all dates on one tab where you can filter for the months. Then just use sumproduct on the master sheet.
    Or, ONE file with ONE tab and all data and use filter with SUBTOTAL at the top for the filtered data

    Attach your file(s) and I'll show you.
    Attached Files Attached Files

  4. #4
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    I am sick and can't work on this but here is the basic idea then use autofilter

    Month adavisor Military Member Military Spouse Civilian or Dependent Total
    Don Guillett
    Excel Developer
    dguillett @gmail.com

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Don

    Concentrate on getting well.
    Get well soon.

    zeddy

Posting Permissions

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