Results 1 to 5 of 5

Thread: Need to average Multiple worksheets into one

  1. #1
    Seeker Emanuel Levy's Avatar
    Join Date
    Jan 2013
    Location
    Toms River, New Jersey, United States
    Posts
    19
    Articles
    0

    Need to average Multiple worksheets into one



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have attached a generic sheet that I have 52 copies of one for each week in the year. I need to create a sheet that will show the total calls for each category over a year based on the day

    Example I need to go through all 52 sheet and add up the # of calls for Monday, Then Tue, etc up to Friday. I don't know how to do this so I need assistance please.
    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    676
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Is it reasonable to think you actually have 52 workbooks one for each week in the year?
    If so, what are they named?

  3. #3
    Seeker Emanuel Levy's Avatar
    Join Date
    Jan 2013
    Location
    Toms River, New Jersey, United States
    Posts
    19
    Articles
    0
    Quote Originally Posted by NoS View Post
    Is it reasonable to think you actually have 52 workbooks one for each week in the year?
    If so, what are they named?

    Yes I have 52 workbooks they are named WEEK 1 2014.xlsx through WEEK 52 2014.xlsx

  4. #4
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    676
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Emanuel

    Not sure what you want can be done with formulas.

    Don't know what folder your weekly workbooks are in.
    Don't know if all 52 workbooks are already in existence.
    Don't know where or what you expect for your results.

    Here's a VBA solution that runs slow as molasses but will import your weekly totals into a workbook and from there you can do what ever you like with the information.

    You'll need to set the required path in the macro.

    Probably not what you wanted but hopefully will be of some value if nothing other than for a look-see.

    Good Luck with your project
    NoS
    Attached Files Attached Files

  5. #5
    Seeker Emanuel Levy's Avatar
    Join Date
    Jan 2013
    Location
    Toms River, New Jersey, United States
    Posts
    19
    Articles
    0
    Quote Originally Posted by NoS View Post
    Emanuel

    Not sure what you want can be done with formulas.

    Don't know what folder your weekly workbooks are in.
    Don't know if all 52 workbooks are already in existence.
    Don't know where or what you expect for your results.

    Here's a VBA solution that runs slow as molasses but will import your weekly totals into a workbook and from there you can do what ever you like with the information.

    You'll need to set the required path in the macro.

    Probably not what you wanted but hopefully will be of some value if nothing other than for a look-see.

    Good Luck with your project
    NoS
    NoS thank you. I will look at the macro tomorrow

Posting Permissions

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