Forum Discussion
Converting excel data into a printable calendar template
Katrina Thompson Correct. Believe this one is easier, because you want the monthly view.
Riny_van_Eekelen Thank you for this. I have modified it for my use, but am just wondering if you could share any tips on how you created it. Is it all excel filters, or does it use any power queries etc? As I would like to understand it a bit better in case I need to make further edits.
- I'm just trying to modify the template above for something that I need it for. I am trying to have the capability of including various Types/Categories in a Master spreadsheet (i.e. the events sheet), but then being able to filter those categories so I can view a calendar for just one Type/Category. So, to relate it to the Marathon template, I would want to have Walk, Run, Race in the Events spreadsheet, but then be able to filter them so I could just view a Walk calendar or a Run calendar. Does that make sense? I am not sure if this is possible, but it would really help. Thanks!
al_fa1922 You are trying to add functionality to customised template. What you have in mind. If you only want ro show "Walk" why not create a calendar with only "Walk" entries?
- Yes, my apologies. I realized that after I sent the message. But, let's say I want to just view my "Walk" schedule on the calendar. Is there a way to filter that or change the concentration of the month and week sheets?
Riny_van_Eekelen Yes, the Berlin mara attachement.
I think I have it doing what I want so many thanks
al_fa1922 There are no drop-downs in this template, other than the month and week. So, what do you mean? The filter button in Events show Race, Run Walk just because these words were entered in column D in the first sheet.
The Month and Week sheets just concatenate Type and Distance from the Events sheet in the calendar sheets.
- Hi! I am wondering if there is a way to only show one "Type" on the calendar. For example, on the first sheet, you can apply a filter that only displays "Walk." But is there a way to only display "Walk" on the calendars on Sheets 2 and 3?
Dearbhla1690 That's a broad question. What exactly are you referring the to? The attachment to my previous post? If so, that one does not use Power Query. My modification to the template was to replace a VLOOKUP that returned the words "Assignment due" if it found something for that date in the event list. Quite useless.
With TEXTJOIN and FILTER, I could at least display the descriptions of all events at a particular date. Not really much tips I can give unless you ask specific questions.
