Need to average Multiple worksheets into one

Emanuel Levy

New member
Joined
Jan 14, 2013
Messages
19
Reaction score
0
Points
0
Location
Toms River, New Jersey, United States
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.
 

Attachments

  • Generic.xlsx
    30.1 KB · Views: 13
Is it reasonable to think you actually have 52 workbooks one for each week in the year?
If so, what are they named?
 
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
 

Attachments

  • Day_Totals_For_Weeks.xlsm
    39.5 KB · Views: 6
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
 
Back
Top