I am trying to create a document to track hours from many different project management documents. I tried using vlookup but it doesn’t work on different sheets. Can someone help or suggest a way to add hours of every employee tracked across multiple projects.
Hi @Vaibhav ,
You may consider having a summary sheet in each of your workbooks which calculates the aggregates for that workbook.
Next, you can create a dedicated Summary workbook, with relationships to Summary sheets in each of your existing workbooks. Using this relationship, you can pull individual workbook aggregates into this one workbook.
Once done, you can now use formulas in this top-level workbook having condensed data from other workbooks, to calculate aggregates across all documents in workspace.
Another alternative is to use Reports to collect and consolidate summary data from individual workbooks into one entity.
Request you to also refer these community threads wherein similar requirements were discussed:
2 Likes