Auto populate holiday tracker from year planner


New Member
Dec 16, 2016

I have a 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".



Well-known Member
Jul 28, 2004
Rule #13 :
We prefer that members do not cross-post questions to other forums, but when this does occur members should do the following:
- Post the details of your question on our forum. Do NOT simply post a link/re-direct to the question in another forum with no details posted here.
- Make it clear that you have cross-posted and provide links to the cross-posts.
Cross-posted questions that do not comply may be deleted or locked. For a discussion on the issues with cross-posting, see this link: Excelguru Help Site - A message to forum cross posters

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...