Results 1 to 4 of 4

Auto populate holiday tracker from year planner

Threaded View

  1. #4
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    365
    Posts
    184

    Re: Auto populate holiday tracker from year planner

    Ok so I think I solved this myself taking on everything I've learned since coming here.

    I added sheet "Holidays Taken" to calculated number of days holiday input on "Planner" sheet which is recorded as initials of name represented by helper column H on sheet "Employees".
    Formula on "Holiday Overview" for each employee and month corresponding is multiplied by helper column F sheet "Employees" which is then basically days holiday*hours worked.

    Everything works as I intended but my question is, have I gone about things the long way? Did I need all the helper columns/pages I have setup or was there a simpler way?

    Either way it works so I have accomplished something

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Holiday Planner stopping clashes of holiday?
    By RayLavidge1908 in forum Excel General
    Replies: 2
    Last Post: 08-09-2018, 10:40 AM
  2. Replies: 5
    Last Post: 02-14-2017, 04:27 PM
  3. working on a holiday planner based on various holiday anniversary dates
    By marktc19 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2017, 09:26 AM
  4. Updating holiday planner for this year?
    By colgor in forum Excel General
    Replies: 7
    Last Post: 10-12-2016, 06:48 AM
  5. Holiday planner/tracker
    By ukphoenix in forum Excel General
    Replies: 6
    Last Post: 04-16-2012, 07:37 AM
  6. Excel 2007 : holiday planner- auto update
    By cooksey2000 in forum Excel General
    Replies: 5
    Last Post: 04-13-2010, 12:30 PM
  7. [SOLVED] Holiday Planner show holiday taken?
    By Mac5 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2006, 01:23 PM

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