Data Table to Calendar in Excel

[snaplink22]

Hello,

I have a data table that I would like to convert into an Excel calendar in the same workbook. I've scoured the internet and have not been able to find a solution to my challenge.

Here is an example that I found online of what I'm looking to recreate:

 

[Larry Haydn]

This is quite an involved process if using VBA programming.

Considerations:
1. How many months of calendar do you want to create
2. If multiple months, which is the first month, last month
3. How many rows do you want for entries in each day

Requirements:
1. An interface to input or select Start Month, End Month
2. An interface to define the number of rows per day (number fo entries allowed per day)
3. A reference table to link the Date to a Cell on the calendar

Transferring the activities into the Calendar:
1. Loop through the date and activity
2. Look up the cell against the date in the date-cell reference list
3. Post the activity into the first available cell, subsequent activities into the next row, etc.
4. Repeat until no more activity

 

[Larry Haydn]

After the Requirements (previous post):
Create the calendar based on the specifications