Forum Discussion

tammyangel's avatar
tammyangel
Copper Contributor
Jul 20, 2021

Converting excel data into a printable calendar template

My work runs about 200 events per year. These are listed in an excel spreadsheet. However they also have a word template which has the layout of an annual calendar. This means there are months acr...
excel
training
RickJ80's avatar
RickJ80
Copper Contributor
Sep 18, 2023

Riny_van_Eekelen 

 

So far you have been very helpful. I still can't adapt the table for my needs. Some of my needs are for a class name

 

Class name  | Date| Date| Date| etc. (up to 12 possible dates)

 

Is there a way to see the table on a normal calendar view or is the list the only way to use that raw data?

 

Thanks for your insight

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Sep 18, 2023

RickJ80 Share a file please, because it's difficult to visualise how Class, Date, Date, etc will affect the calendar.

  • RickJ80's avatar
    RickJ80
    Copper Contributor
    Sep 18, 2023
    I couldn't figure out how to send a file
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Sep 19, 2023

      RickJ80 Save your file to Onedrive or similar and than copy/paste the link that gives access to it in your reply. Or send it to me via a direct message. Click on my 'name-tag', then Message. Now you can drag and drop a file in the appropriate place.

  • RickJ80's avatar
    RickJ80
    Copper Contributor
    Sep 18, 2023

    Riny_van_Eekelen  Something like this where I can assign a specific name under the first block. The 24 block would be where I enter in the specific class name.

     

    24Jan1/8/20241/9/20241/10/20241/16/20241/17/20241/18/20241/22/20241/23/20241/24/20241/29/20241/30/20241/31/2024
    24Jan1/22/20241/23/20241/24/20241/29/20241/30/20241/31/20242/5/20242/6/20242/7/20242/12/20242/13/20242/14/2024
    24Feb2/5/20242/6/20242/7/20242/12/20242/13/20242/14/20242/20/20242/21/20242/22/20242/26/20242/27/20242/28/2024

Resources