Forum Discussion
Populate dynamic calendar with table data
Mthammon The calendar template you chose isn't well suited for what you have in mind. As most templates, it's packed with tricks and treats. This particular one is full of named formulae. Neat, but near to impossible to tweak without destroying something else. But, there are templates "out there" that can do what you need. Not too long ago, I adapted such a template for another user on this forum, though it uses the rather new FILTER function. The original template just highlighted that "something was due" on a particular date without specifying what. After my adaption it actually displays the assignment(s) due on a given day.
I took a few columns from your data sheet and dumped them in the template. See if it works for you (file attached). If not, keep searching for a better template.
Riny_van_Eekelen - I luv your work! I had a question around the possibility taking the calendar view to another level ie from Month and Week view to a Daily view (with times of the work day ie 8am to 6pm). Is that something that's relatively easy to do? I'm an older adopter on excel and am keen to learn. Kind regards.
Hi Michael,
That would be a major task, I believe. Not something that can be achieved by a simple modification to an otherwise not very well designed template. Note, that I modified it to make it a bit more useful, though.
The functionality you describe (and much more) is what's available in all calendar apps that sit on every computer and/or smart phone nowadays. To be honest, I would never use Excel for these kind of tasks myself. It is far too complicated to develop and maintain.
Riny
Riny_van_Eekelen Thanks for responding so quickly. I understand and appreciate your insights.
Kind regards