I've searched the forum for a solution but haven't been able to find anything that quite meets my needs. I have an Excel 2010 workbook (copy attached) that will be used to track metrics for people in my group over the course of the year. So far I have designed it so each person has their own tab where they can type in their metrics at the end of each week. I'm using a formula to automatically compile the info from each person's tab into the overall worksheet for that week. I then have a macro button that I push that inserts a new worksheet for the coming week, copy's the formulas, does a copy/paste values on the current week, then clears the contents on the input tabs. So I have a nice weekly report with a running YTD column.
What I'm needing is a macro that can take the information from the weekly worksheets and compile it into a Summary worksheet broken down by month. So, it will somehow need to identify all the weekly worksheets for January and total the cells into the respective location on the summary sheet, then do the same for Feb, March, etc. I know that if I just had 52 weekly worksheets already created I could use a formula to do this. But, I'm assuming I'll need a macro to do it for a dynamicly changing workbook.
I don't really undersand VBA. What I have in this workbook so far is just stuff I picked up searching the forums. Any help would be greatly appreciated.
Weekly Report With Summary Template.xlsm