+ Reply to Thread
Results 1 to 2 of 2

Populate name/vacation date information into calendar format in separate tab

  1. #1
    Registered User
    Join Date
    Vancouver, Canada
    MS-Off Ver
    MS Office Home and Business 2010

    Populate name/vacation date information into calendar format in separate tab

    I found a similar example thread but have lost the link...I know that user Pete_UK generated the sample file "ef159_Vacation_Calendar", attached here, as a reference and it gave me hope but I don't have the knowledge to integrate it into the sheet I have created, also attached. (Primarily as my source content runs across the columns rather than down the rows.)

    I would like to link the vacation dates and employee name indicated on the appropriate dates in a separate calendar tab. My goal is to have all the primary tabs with information hidden so that only the calendar tab is visible to employees for vacation planning purposes. I do not want any of the other types of leave to be shown in the calendar as that is not information that all employees should see. I'm using Excel 2010 and would appreciate any assistance!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    Warrington, England
    MS-Off Ver
    Excel 2007

    Re: Populate name/vacation date information into calendar format in separate tab

    The template that you attached has no example data in it, but it would appear that you use this by entering the appropriate code into one of the monthly sheets once the list of employees has been set up. Are you hoping to get the data from these 12 monthly sheets and put it into the style of a calendar?

    The calendar file of mine that you also attached works from one list (which can be entered in any order) and it would be quite a big job to convert it to get data from 12 separate sheets.

    To be honest, it's not exactly clear to me what you are trying to achieve, so perhaps you can expand on your description of this.

    Hope this helps.


+ 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. Populate an Excel calendar template with events from a separate table
    By Dana_Carter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2014, 12:14 PM
  2. [SOLVED] Trying to get vacation tracking spreadsheet to automatically populate calendar
    By wdry7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-17-2014, 05:03 AM
  3. 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
  4. Auto populate vacation calendar dates per employee
    By boxermack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2013, 11:47 AM
  5. Replies: 0
    Last Post: 07-03-2012, 03:52 PM
  6. Vacation Accrual - hire date and calendar year
    By dgohmann in forum Excel General
    Replies: 0
    Last Post: 12-09-2010, 01:21 PM


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