Auto Populate a Yearly Calendar

Hi all,

I'm a newly joined member after reading through quite a lot of posts that relate to what I would like to do. I haven't found anything that matches what I am looking for a solution to.

Please tell me if this should go somewhere else.

I am hoping to auto fill dates on a yearly calendar with a name and task from two columns by date. This data sheets will be kept by month.

The idea would be that if a due date says 02/07/15 for a name and task, this would auto fill in the box of the yearly calendar for that date.

There may be times when there is more than one task due on a date.
I've attached two files that demonstrate what I am talking about (I hope). Again, if this should go elsewhere please tell me.

Hi here is a very simple Code to fill a column with the Dates from year x to y
Ah sorry just saw your attachment and figured you want something else :D

Sub make_calendar()
Dim ws As Worksheet
Dim Counter As Long
Dim Startyear As Integer
Dim endyear As Integer

Startyear = 2015
endyear = 2017


Set ws = ThisWorkbook.Sheets("Calendar")
Counter = 1

For i = DateSerial(Startyear, 1, 1) To DateSerial(endyear, 12, 31)
 ws.Cells(Counter, 1).Value = i
 Counter = Counter + 1
Next i
End Sub