Forum Discussion
Converting excel data into a printable calendar template
Hi Riny,
This is great exactly what i'm looking for
I have copy and pasted the 'month view' to my 'Actions Tracker' spreadsheet but am struggling to adapt the formula to pull events into the month view
I believe changing the array is what will do it but need some pointers if you can help with this
Thank you
Azaam_Emambacus Not sure what you are trying to achieve, but if you are taking the Month View sheet and copy/paste it into another workbook, you would have to structure the event list (table name, column headers etc.) in that new workbook the same as in the file I uploaded earlier. It might work, but I can't guarantee it. It's not something I designed myself. I merely adjusted an otherwise totally useless template that's offered on-line.
Darren2480 Is it also possible to simply and automatically generate a calendar similar to the one shown in the image below based on data from an Excel Spreadsheet (Tasks follow each other after a certain duration). Would this be possible in Pivot Tables or the like? If so, would you be able to provide some instructions on how to achieve this.
In addition to a Weekly Forecast, I also need to be able to produce a Monthly Forecast based on the same (but obviously more extensive) data.
How do you suggest I best tackle this? Many thanks for any assistance you can provide in this matter.Using the Berlin calendar as an examples can you have a start date and end date that would report that event each day during the time frame or would each event need their own data entry?
And thanks your answers have so far been very helpful
Riny_van_Eekelen : Because Microsoft Excel on my laptop is version 2019 so can not run with Formula: Textjoint & filter.
Do you have another solution for Version 2019 below with Microsoft Excel for this case. ?
