Forum Discussion
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...
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.
Riny_van_Eekelen Yes, the Berlin mara attachement.
I think I have it doing what I want so many thanks