Forum Discussion
Task List that transfers to Calendar
- Sep 19, 2021
mendthefabric A couple of days ago another student asked a similar question. He/she chose to work with a typical Calendar template found on-line, with a monthly and a weekly view. Though, it only marked days that something was due, but it didn't specify what. I slightly modified that template to achieve just that and could dump your assignments into the modified template. The calendar views were filled instantly. No VBA needed.
Personally, I would never use this kind of template. It's full with "features" that make it difficult to adapt to ones specific needs. So, use it as it is and don't try to tinker with it too much. Take it, or leave it, I would say.
Oh, and since you tag your posting with "Office365", I assume that your Excel version supports the FILTER function. If not, you may disregard the attached workbook.
mendthefabric A couple of days ago another student asked a similar question. He/she chose to work with a typical Calendar template found on-line, with a monthly and a weekly view. Though, it only marked days that something was due, but it didn't specify what. I slightly modified that template to achieve just that and could dump your assignments into the modified template. The calendar views were filled instantly. No VBA needed.
Personally, I would never use this kind of template. It's full with "features" that make it difficult to adapt to ones specific needs. So, use it as it is and don't try to tinker with it too much. Take it, or leave it, I would say.
Oh, and since you tag your posting with "Office365", I assume that your Excel version supports the FILTER function. If not, you may disregard the attached workbook.
Is it possible to add the Class to this as well? So it might read
CLASS: Assignment
on the specific date in both month and week views? I have not programmed anything in years, and tried to add it in and am getting a syntax error.
- Riny_van_EekelenJan 31, 2023Platinum Contributor
criley03 Easiest would be to expand the table with a MERGED column where you concatenate the Assignment and Class columns into one. Then, in the Month and week views use Find&Replace.
Find what?
[[DESCRIPTION]:[DESCRIPTION]]
Replace with?
[[MERGED]:[MERGED]]
See attached.
- criley03Jan 31, 2023Copper ContributorThank you so much. Once I did some digging, I realized I what I was trying wasn't going to work. I picked up enough to follow along with what you are saying. It's exactly what I was looking for. Thank you!