Create summary sheet

[trebor1956]

Hi I am using excel 2013. I have individual sheets for each team member that use 'networkdays' to calculate holiday used between a start and end date. I would like to put a letter 'R', 'A' or 'D' in columns in a summary sheet depending who has booked holiday.
I can't attach the workbook I am trying on so I have copied the relevant sheets below. I just can't seem to get my head round it so have cleared all my attempts so far. Any help would be greatly received.

Worksheet for Rob

From Date To Date Half day? Hols Left 14/12/2017 15/12/2017 2 8 21/12/2017 21/12/2017 Y 0.5 7.5 02/01/2018 02/01/2018 1 6.5 <colgroup><col span="2"><col><col><col></colgroup><tbody> </tbody> Worksheet for Andy From Date To Date Half day? Hols Left 03/01/2018 05/01/2018 3 7 02/02/2018 03/02/2018 Y 0.5 6.5 03/03/2018 08/03/2018 4 2.5 <colgroup><col span="2"><col><col><col></colgroup><tbody> </tbody> <strike></strike>Summary sheet Rob Andy Dene Rob Andy Dene Rob Andy Dene 01/01/2018 01/02/2018 01/03/2018 02/01/2018 02/02/2018 02/03/2018 03/01/2018 03/02/2018 03/03/2018 04/01/2018 04/02/2018 04/03/2018 05/01/2018 05/02/2018 05/03/2018 06/01/2018 06/02/2018 06/03/2018 07/01/2018 07/02/2018 07/03/2018 08/01/2018 08/02/2018 08/03/2018 09/01/2018 09/02/2018 09/03/2018 10/01/2018 10/02/2018 10/03/2018 11/01/2018 11/02/2018 11/03/2018 12/01/2018 12/02/2018 12/03/2018 13/01/2018 13/02/2018 13/03/2018 14/01/2018 14/02/2018 14/03/2018 15/01/2018 15/02/2018 15/03/2018 16/01/2018 16/02/2018 16/03/2018 17/01/2018 17/02/2018 17/03/2018 18/01/2018 18/02/2018 18/03/2018 19/01/2018 19/02/2018 19/03/2018 20/01/2018 20/02/2018 20/03/2018 21/01/2018 21/02/2018 21/03/2018 22/01/2018 22/02/2018 22/03/2018 23/01/2018 23/02/2018 23/03/2018 24/01/2018 24/02/2018 24/03/2018 25/01/2018 25/02/2018 25/03/2018 26/01/2018 26/02/2018 26/03/2018 27/01/2018 27/02/2018 27/03/2018 28/01/2018 28/02/2018 28/03/2018 29/01/2018 29/03/2018 30/01/2018 30/03/2018 31/01/2018 31/03/2018 <colgroup><col><col><col span="2"><col><col><col span="2"><col><col><col span="2"></colgroup><tbody> </tbody> <strike></strike> <colgroup><col span="2"><col><col><col></colgroup><tbody> </tbody>

<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>

 

[crazydragon84]

dude i have no idea what you are trying to accomplish or what the actual summary sheet should look like... you need to clarify more.

 

[TimNevins]

Not to be a pest, but do these people accrue holiday hours throughout the year? In order to calculate remaining holiday you need to account for those hours. I think what you need to do is make an entry for each day in the user sheets, then you can use index, match to grab the values by day from each user sheet. As it is, you are going to have to parse those multiday values to be able to get discreet values for each date.

Good luck!