+ Reply to Thread
Results 1 to 4 of 4

Trying to get vacation tracking spreadsheet to automatically populate calendar

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    Highlands,Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Trying to get vacation tracking spreadsheet to automatically populate calendar

    I have an employee absence tracking spreadsheet that I would like for it to make an automatic entry onto an excell calendar, whenever an entry is made for that date, but it must also be able to make that entry for a max of 3 employees out of 14. (say employee 1 takes off vacation on January 6, 7, 8, 9 & 10) it would populate my excell calendar for those dates, with employee 1's name. The tracking sheet also tracks sick leave and roving holidays, but it only needs to tell me on the calendar who is off, not what type of day they are taking off. I really want to stay with the calendar format, and not a chart or dashboard view. I have attached what I have, and would appreciate any help.Example.xlsx

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,640

    Re: Trying to get vacation tracking spreadsheet to automatically populate calendar

    Take a look at this thread:

    http://www.excelforum.com/excel-form...e-to-tab2.html

    it might give you some ideas.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    03-27-2013
    Location
    Highlands,Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Trying to get vacation tracking spreadsheet to automatically populate calendar

    Thanks Pete!, it did give me an idea and it solved my problem. Since I wanted my calendar to populate a name when an entry was made on the tracking sheet(vacation, sick leave, or roving holiday), I designed my calendar with 14 cells for each date, 1 cell for each employee, and I used the following formula for each cell: =if(sum(January!C7,January!C8,January!C9>0),"employee 1"," ") any entry into any one of the cell groups would render a true condition and would populate the calendar with their name, no entry on the tracking chart and the calendar cell would remain blank. It did get rather teadious building the calendar. Thanks Again.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,640

    Re: Trying to get vacation tracking spreadsheet to automatically populate calendar

    Glad I was able to set you on your way.

    If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ 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. ASSEST TRACKING - Automatically plot on a calendar when Assets are used.
    By citadel-maritime in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2013, 09:26 AM
  2. VBA to automatically populate Excel calendar with staff vacation (leave) data
    By batteredveg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2013, 04:09 PM
  3. Auto populate vacation calendar dates per employee
    By boxermack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2013, 11:47 AM
  4. Vacation Tracking
    By sherriehere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2011, 02:18 AM
  5. vacation tracking calendar on exel sheet for 2006
    By Carol in forum Excel General
    Replies: 0
    Last Post: 11-21-2005, 02:50 PM

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