VBA code to copy name in column against dates

[vinmam123VBA]

Hi All,

I am trying to come up with code which will help me in pasting name in the column against dates in other column.

For example assume I have five names below

Vinayaka1
Vinayaka2
Vinayaka3
Vinayaka4
Vinayaka5


I would like to enter all dates of particular month in the column A and then paste Vinayaka1 in column B against all the dates in column A

Again I need to enter all dates of Particular Month in column A and paste Vinayaka2 in column B and so on

Can some one help me with the above requirement

Regards,
Vinmam123

 

[vinmam123VBA]

Can someone please help!!