Here's the problem that I need to solve. There will be workers that put in their hours and task for every day of the week and I need them need the "task" and the "worker" to go over into the "project summary" and then the hours for all of the weeks to be summed up. That way the project manager can get a sum of what is essentially total hours spent by each worker for each task across all weeks. I was thinking of just doing it with formulas (like a vlookup combined with sumif) I have the "worker" and the "task" set up as data validation lists so I really just need those hours to auto-populate. Any help would be appreciated.
Excel Vlookup and sumif function maybe a macro issue?
- Thread starter Excelman
- Start date
Here's the problem that I need to solve. There will be workers that put in their hours and task for every day of the week and I need them need the "task" and the "worker" to go over into the "project summary" and then the hours for all of the weeks to be summed up. That way the project manager can get a sum of what is essentially total hours spent by each worker for each task across all weeks. I was thinking of just doing it with formulas (like a vlookup combined with sumif) I have the "worker" and the "task" set up as data validation lists so I really just need those hours to auto-populate. Any help would be appreciated.
