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.
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_EekelenSep 18, 2023Platinum Contributor
RickJ80 Share a file please, because it's difficult to visualise how Class, Date, Date, etc will affect the calendar.
- RickJ80Sep 18, 2023Copper ContributorI couldn't figure out how to send a file
- Riny_van_EekelenSep 19, 2023Platinum Contributor
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.
- RickJ80Sep 18, 2023Copper Contributor
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.
24 Jan 1/8/2024 1/9/2024 1/10/2024 1/16/2024 1/17/2024 1/18/2024 1/22/2024 1/23/2024 1/24/2024 1/29/2024 1/30/2024 1/31/2024 24 Jan 1/22/2024 1/23/2024 1/24/2024 1/29/2024 1/30/2024 1/31/2024 2/5/2024 2/6/2024 2/7/2024 2/12/2024 2/13/2024 2/14/2024 24 Feb 2/5/2024 2/6/2024 2/7/2024 2/12/2024 2/13/2024 2/14/2024 2/20/2024 2/21/2024 2/22/2024 2/26/2024 2/27/2024 2/28/2024