Auto populate holiday tracker from year planner

Hi,

I've already had so much help with building this tracker so thanks to everyone so far. But I have made an amendment by adding sheet "Planner" where I can input the holidays taken by employees. All these sheets currently work fine as they are if I were to input data manually.

What I am looking to do is auto populate sheet "Holiday Overview" cells C4:N28 with the hours holiday taken which is based on the information input on sheet "Planner".

My theory is that I enter the number of days holiday taken on the "Planner", multiply this by the hours worked each day (so I added column F on sheet "Employees") and then this is the number of hours holiday to add to the corresponding cell on sheet "Holiday Overview". The number of cells filled in on the "Planner" will represent the number of days worked each week which is shown in column G sheet "Employees". I have set marco buttons to add/remove holiday, and then I type the first name of the employee.

The result required is, enter holiday on the "Planner" with first name, cross reference this with the name and month on "holiday Overview" and enter the number of holiday hours taken. This would mean matching the month on "Planner" to the month on "Holiday Overview", matching the name on "Planner" to the first name on "Holiday Overview", and live updating this as holiday is added/removed on the "Planner".

I have attached the blank workbook, I will comment below with an example of the results I require. I'm sure its possible but there are just to many references for me to work out.

Thanks

Cross Post: https://www.mrexcel.com/forum/excel-...r-planner.html