Forum Discussion
Converting excel data into a printable calendar template
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.
Riny_van_Eekelen This was really helpful! Thanks.
Let's add a few more levels of complexity...
1. Let's use the previous example of 200+ events. Is it possible to add an event type to the data? Without it being part of the event name?
2. I understand that the original question was to format the calendar to be the large yearly calendar. Is it possible to format the pivot table to look like a 'regular' calendar?
Thanks in advance,
1) Yes, that is possible. How would you want to use the event type in the calendar?
2) How would a "regular" calendar look like for you?
Thanks for the quick reply.
In my use case, I'm collecting a list of workouts related to different running races. I'm training for several races and each one has a different schedule. I'm trying to consolidate all of those in one place.
I'm attaching a spreadsheet based off your original reply.
- This was a great alternative. I tried it for our company holidays, for each country and the by month view works out great.
