This is pretty good. What I want is slightly simpler.... I want to have a task column and a date column. And then on another tab, have a calendar that autofills the task content into the calendar, based on the date entered in the date column.

Example: Enter in January 1, 2014 as date and task is "Take out the garbage." I want "Take out the garbage" to show up on the calendar on the next sheet on the right day. What part of the code in this vacation sheet would do that?