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
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 20, 2021

tammyangel Perhaps you are willing and able to move away from Word, because you could do all within Excel, with Power Query / Power Pivot (provided you are working on a PC, not a Mac).

 

The attached workbook contains an example that demonstrates what's possible. Sheet1 contains the Events listing (Date, Event) and Sheet2 has a (power) pivot table with the Annual Calendar view you described. All don in a quick-and-dirty manner and most likely it needs to be adapted to your real situation.

 

Change the events listing (change a date, add, delete, rename), and refresh the pivot table. That's it! 

 

Edit: Added another file ("tammyangel-2.xlsx) . Power Query only. Personally I prefer that one.

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