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 Hi! That template is almost exactly what I'm looking for for my grand opening calendar for work. I've been tasked to create it all by Friday, 1/20/23, and just found out this week. I've been scrambling everywhere to learn or find templates, so this is my last resort. Can you please help me create a calendar for the attached checklist items? I tried to use your template but I'm not sure how to unlock things to have my own information aside from dates. In the attachment, I have one tab that is the original checklist with the formulas I use to populate the dates since they are constantly changing, but also included one that has no formulas at all. Please help if you can!! It would be much appreciated!!
https://togos-my.sharepoint.com/:x:/p/alexis_bynum/EUMiirJZPEBAkBIQyHsZcrsBtIotv2aC3QlYQuUnjFWNOQ?e=UqmJOI
alexisbynum Perhaps like in the attached file?
Riny_van_Eekelen Hi, I have to tell you how grateful I was to find this thread. I spent the better part of the last two days trying to figure this out with no success. I was able to adapt the calendar for what we need but I was wondering if there was a way to have the "Assignment" show on a "Start Date" through an "End Date". I hope that makes sense. I tried to attach the file but it wouldn't let me.
SeaSears That makes perfect sense, though the template dealt with in this thread is not suitable for it. you need to enter assignments on a daily basis. But I wonder why you would want to have a calendar in Excel to begin with. Why not use e.g. the calendar app you probably already have on your computer, e.g. in Outlook? Just a thought. I would never use a calendar developed in Excel myself.
Riny_van_Eekelen hi I’d also like to have the “event” show on the calendar each day from start to finish. I’m using this as a holiday tracker for a project team so seeing the days each person will be out of office with overlap would be helpful.
- Hi Reny, hope you are well.
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
Riny_van_Eekelenhi,,,hope u r well...i have make my calendar using your template file...but there is only 1 problem that when i send that file to another pc through email it will not apear as it is. As month changes content will disapear..how i can send amended file with no restrictions.
Riny_van_Eekelen Yes! Thank you! Is there a way to remove the word assignments and replace it with “Tasks” from all the other notes and such without messing things up?
alexisbynum Just enter it in the cell BR. It's just a header that is not used in any formula. And if you want you can also change the sheet name to Tasks. Formulas will update automatically.
Edit: Now see that are some more ASSIGNMENTS floating around that cause trouble. Attached a new version.
Riny_van_Eekelen I have been reading this thread and I like this spreadsheet you have created in both cases. I was wondering if it is possible to create multiple “task” tabs/worksheets and have the task filter into the same calendar? My team has multiple projects and I would like to have each members project in a worksheet, but their tasks appear on the same calendar. Is it possible?
