I have a task from my boss that would help him out a lot. I attached a dummy spreadsheet so you can see what I'm talking about. What I need to do is have a different tab for every month and then the "totals" tab will automatically update with the total amount of hours each person worked on each project and phase. When a new month is added, I want it to be able to account for this automatically (or with very little change to the code) and update the total spreadsheet with new projects and the new total amount of hours. I don't have much VBA experience, but I figured this would be the only way to do this. Please let me know if you have any tips on where I should start!
Bookmarks