+ 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
    01-11-2019
    Location
    Vancouver, Canada
    MS-Off Ver
    MS Office Home and Business 2010
    Posts
    1

    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
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    16,572

    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.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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