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.
I am customizing this template that you originally provided in 2021 (saving me tons of time...thanks!)
Wondering how to edit the "pop up instructions"...doesn't give the the option as comment or note.
Thanks!
Captain_T Those pop-ups are Data Validation input messages that came with the original template.
So, select all cells with similar validation rules. On the Data ribbon, Data Validation, Input Message, Clear All. OK.
Just save your work before doing this, in case you make a mistake.
Thanks again for this help!
I'm now customizing the calendar page and wondering how to duplicate a new formula in all the calendar cells (where to get the entries that show on the calendar) in some automated way? (besides copying and pasting each one...). I hope that makes sense.
Not sure what you have in mind. Best to start a new thread based on your specific situation and showing what you have customised already and you want next.