Forum Discussion
Task List that transfers to Calendar
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.
Riny_van_Eekelen Finally I found the exact answer that I am looking for? If there a formula to have task lists with due dates auto populate into an excel calendar? similarly to what you have done...
I ask because for work, we have a spread sheet similar to the task list with dates were documentation is due, our "tasks" are separated by different categories. It would be so much easier if we had a calendar to visualize when certain documentation is due based on that spreadsheet... SOS plz
Richelene Well, have you tried to adapt you task list to the format used in the template I uploaded earlier (HW cal.xlsx)? As mentioned, such templates are difficult to adapt to everyone's needs. So, in principle, you'll have to adapt to what the template offers you.
