Forum Discussion
how to show what projects each person is working on
Hi we have a project spreadsheet, which all the projects we have going on in our department on it. We also want to add a workload tab which shows how many hours people are working on each specific pr...
itsemeliii hard to tell without seeing some example, but you could use sumif formulas to sum a group of worksheets directly:
https://exceloffthegrid.com/how-to-sum-the-same-cell-across-multiple-worksheets/
I used this extensively to consolidate budget figures, each worksheet would be from a different division.