+ Reply to Thread
Results 1 to 3 of 3

Auto populate holiday tracker from year planner

  1. #1
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    2013
    Posts
    63

    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
    Attached Files Attached Files
    Last edited by jeffreybrown; Yesterday at 08:05 AM. Reason: Cross Post added

  2. #2
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    2013
    Posts
    63

    Re: Auto populate holiday tracker from year planner

    Example with holiday data input as required
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    2013
    Posts
    63

    Re: Auto populate holiday tracker from year planner

    Still in need of help if anyone has a solution, I can give further examples if necessary.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1