Convert weekly data into monthly data in VBA

[yangkaiyu]

Hello, I need some help

I have a worksheet called data weekly.
C4 to C108 are the date. (C4 = 2017/06/23)
D3 to AA3 are the assets.
D4:AA108 are the index of those assets.

I want to convert those data into monthly data in another worksheet called data monthly VBA.
(start from D4) C4= 2017/0630, C5 = 2017/07/31...until C27.

Please help me with that.

 

[DanteAmor]

Hello, I need some help

I have a worksheet called data weekly.
C4 to C108 are the date. (C4 = 2017/06/23)
D3 to AA3 are the assets.
D4:AA108 are the index of those assets.

I want to convert those data into monthly data in another worksheet called data monthly VBA.
(start from D4) C4= 2017/0630, C5 = 2017/07/31...until C27.

Please help me with that.

Do you only want the dates?
You could put an image of what you have on the sheet "weekly" and another image of what you expect from the result on the sheet "monthly"