TimeSheet Consolidation

[adhibi01]

I have Timesheets of multiple resources with hours for multiple days in SHEET 1.
I would like to have this calculated and updated accordingly in SHEET 2 where it displays - one line for a resource irrespective of their project and day with the total number of hours spent by the resource.

Help is greatly appreciated.

Sheet 1 -
2019-11-08_17-03-58.jpg

Sheet 2 (Desired Output without Manually having to add each of the hours for the resources)
2019-11-08_17-07-11.jpg

[1aaaaaaaaaaaaaaa]

Hi, you could use a pivot table for this? Would that work for you?

[adhibi01]

Thanks I am trying with the Pivot Table but, was not sure if there was another way to do it more efficiently.

[Pepe Le Mokko]

@Poizhan
Administrative Note:

Hi and welcome
although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
So, please update your profile to something more precise then "Jesus is Lord" ( country will suffice, no need to be more precise).
Also note that philosophical views/opinions should be avoided on this forum
Thank you for helping us to help you

[bakerman2]

Give this a go.

Please Login or Register  to view this content.