How to Turn Your Task List into a Calendar (and Why You Should!)

[@josilhus]

I like your approach for this problem Quite cleaver use the text join to overcome the spill error

[@ahmedraouf1252]

Could you please add a link to download the file

[@ramshube9898]

Very nice. Can you show how to add hourly slots or start and end time for multiple tasks in a day?

[@SdMotion]

Thank you, sure will do it

[@kyleneyonemoto7733]

This is great! Thank you!! Question, is there a way to do this via vba or any suggestions to help with refresh/calculation speed? My list is continuing to grow, and because of this, when switching months, it takes forever to update/load. Also, is there a way to fill (multiple dates) with a date range (i.e. vacation from Jan 1st - Jan 5th)?

[@SdMotion]

Of court why not, VBA will automate this

[@kyleneyonemoto7733]

@ is this something you would be able to help with? Thanks in advance

[@SdMotion]

@kyleneyonemoto7733 will upload a video on this sooner