+ Reply to Thread
Results 1 to 2 of 2

How to link holiday tracker & Calendar

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 365
    Posts
    85

    How to link holiday tracker & Calendar

    Hi guys,

    I’m currently in the process of creating a holiday tracker/calendar. I’ve attached an example of the tracker below.

    I use “sheet 1” to input the various holidays/sick days etc. for the all the employees.

    This then feeds into the holiday tracker which calculates the individuals holiday balance.

    I now want to data from Sheet 1 to feed into the January calendar. For example I want to see Johns Holiday shown in the calendar under Tuesday 3rd Jan. Does any one know how I can do this please or suggest a better way of executing this.

    Many thanks

    Harry

  2. #2
    Registered User
    Join Date
    10-12-2013
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    36

    Re: How to link holiday tracker & Calendar

    Harry, we're not seeing your example file. To upload it, click to edit your post, then click GO Advanced, then click Manage Attachments.

    Make sure it includes the "sheet 1" you refer to as well as the "holiday tracker" and the "Calendar" sheet(s).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Holiday Tracker - Summary Sheet - Help Needed.
    By Liquidity in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-30-2015, 01:27 PM
  2. [SOLVED] Holiday Tracker
    By Kris_2999 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-26-2014, 03:34 PM
  3. Holiday planner/tracker
    By ukphoenix in forum Excel General
    Replies: 6
    Last Post: 04-16-2012, 07:37 AM
  4. Holiday Leave Tracker Help
    By subtilty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2011, 10:39 AM
  5. Holiday Tracker
    By Benjamin2008 in forum Excel General
    Replies: 4
    Last Post: 02-06-2010, 08:38 AM
  6. Employee Holiday Tracker
    By Benjamin2008 in forum Excel General
    Replies: 4
    Last Post: 02-05-2010, 11:07 AM
  7. holiday tracker
    By vikfowler in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2008, 06:27 AM

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