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.
Can you plz help me in creating a dynamic calendar with auto populate events in excel???
Haya_Khan Can't you work with any of the examples given earlier in this thread? If not, what is your specific need?
- I have worked with your template. After editing it will apear fine but when i email amended file to another PC, after changing month data disapeared and only current month calendar shows. How i can email the same file so it can work as it is on another PC
First of all, it's not my template. I merely adapted an otherwise useless template. Anyhow, I would need to see what you have done. Upload it her or share a link to the file on Onedrive or something similar.
Your all examples are perfect. I just want to learn, making of auto populate dynamic calendar. Plz Help.