Is it reasonable to think you actually have 52 workbooks one for each week in the year?
If so, what are they named?
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.
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
Bookmarks