+ Reply to Thread
Results 1 to 6 of 6

Extracting Data from table to calendar view

  1. #1
    Registered User
    Join Date
    09-05-2019
    Location
    Batesville, Indiana
    MS-Off Ver
    365 ProPlus
    Posts
    6

    Extracting Data from table to calendar view

    I need help extracting data from my table in excel into a calendar view similar to my attachments. I am attaching my spreadsheet that has all of my data in it as well as a PDF showing how I would like to have the data extracted. I would like to continue adding data to my spreadsheet and every 2 weeks where I can choose my dates in the calendar view.
    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
    17,879

    Re: Extracting Data from table to calendar view

    Presumably you don't want to show any data if you have OFF in the Route column, but are there any other codes in there that you don't want to show? Like PTO, or OPEN, or even blanks? Or, do you want to show everything?

    Pete

  3. #3
    Registered User
    Join Date
    09-05-2019
    Location
    Batesville, Indiana
    MS-Off Ver
    365 ProPlus
    Posts
    6

    Re: Extracting Data from table to calendar view

    I think I want to show everything. This helps other team members know if someone if OFF, they might be able to call them if they need someone to work for them versus if they are on PTO they might be unavailable. The OPEN is an open position that needs to be filled.
    Thanks So much!!!

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

    Re: Extracting Data from table to calendar view

    I've set this up for you in the attached file, where I have added a sheet called Calendar which presents the data in the format you outlined in the PDF file. I've also tidied up your Lists sheet a bit to make it a bit clearer.

    I've added two extra columns to your main data table, which help to identify particular records. Various other formulae in the Calendar sheet make use of these in order to form the layout. In the Calendar sheet you can specify the start date in cell F2, which should be a Monday - you will be warned if it is not in the cell below, which will turn red.

    I've allowed 3 extra rows below each Shift block, to accommodate having more data in other weeks.

    Hope this helps.

    Pete
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-05-2019
    Location
    Batesville, Indiana
    MS-Off Ver
    365 ProPlus
    Posts
    6

    Re: Extracting Data from table to calendar view

    I believe this is exactly what I am looking for. Thanks so much!!! I will review more tomorrow. Thanks again!!

  6. #6
    Registered User
    Join Date
    09-05-2019
    Location
    Batesville, Indiana
    MS-Off Ver
    365 ProPlus
    Posts
    6

    Re: Extracting Data from table to calendar view

    I am having another issue. When i was entering this this two week schedule, late, I had an employee leave. When i replace her name in the data tab with "OPEN", it shows her name still under third shift as well as the open position. It is like the calendar view is seeing her name from the previous two weeks schedule.

+ 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