Hi all,

I have created a calendar in excel that I can track the ongoings for each month.  I have set it up so that each day has a set of 5 cells below it so i can add 5 things per date.  I was wondering if there was a way to create a ‘monthly’ to do list on a separate sheet that would automatically add things to it that I am typing in the calendar month sections.

I don’t mind if i end up having to do each date per month with a formula i just really need a work around so i can see tasks/events filtered by the conditional formatting or by the date.

bonus points if the to do list can be split up into monthly sections on the list!

Any advice would be appreciated!

Thank you

Gray 

​Hi all, I have created a calendar in excel that I can track the ongoings for each month.  I have set it up so that each day has a set of 5 cells below it so i can add 5 things per date.  I was wondering if there was a way to create a ‘monthly’ to do list on a separate sheet that would automatically add things to it that I am typing in the calendar month sections. I don’t mind if i end up having to do each date per month with a formula i just really need a work around so i can see tasks/events filtered by the conditional formatting or by the date. bonus points if the to do list can be split up into monthly sections on the list! Any advice would be appreciated!Thank youGray   Read More

​