Hi There
This has been driving me mad for few days now so hopefully someone here can help me out and save me more headache please
So on the attached sample you'll see that I have 2 tabs, one with shift planned and the other one is the summary tab.
What I'd like to do is to take values from each month and put them into summary tab so that I can track hours.
The trick is that as you will see this spreadsheet is poorly designed in terms of data structure (This was created by someone else and I'm not allowed to change layout)
Each colleague is allocated to area of work so what i need is basically a summary of hours worked in each month for each one of the 16 areas..
Is this even possible?
I've tried pivots and vlookup's but could not do it...
Thank You in Advance
Regards
Dan
This has been driving me mad for few days now so hopefully someone here can help me out and save me more headache please
So on the attached sample you'll see that I have 2 tabs, one with shift planned and the other one is the summary tab.
What I'd like to do is to take values from each month and put them into summary tab so that I can track hours.
The trick is that as you will see this spreadsheet is poorly designed in terms of data structure (This was created by someone else and I'm not allowed to change layout)
Each colleague is allocated to area of work so what i need is basically a summary of hours worked in each month for each one of the 16 areas..
Is this even possible?
I've tried pivots and vlookup's but could not do it...
Thank You in Advance
Regards
Dan
