VBA loop to duplicate rows based number of days per month

[mybyby]

Hi guys

I need your help guys to write VBA code to duplicate rows based on number of days per months
I have monthly order number but it is not comparable to daily actuals, what I need is to populate the table into daily file based on number days per month. e.g. I need 31 rows for first data below.

Appreciate your help. Thanks!

Customer Name	EOMDate	OrderQty	Remarks	No of Days per month	DailyTarget (OrderQtyMth/No of days)
AAAA	31/1/2017	17689 <tbody> </tbody>	Store1	31	570.6129 <tbody> </tbody>
AAAA	28/02/2017	1,806 <tbody> </tbody>	Store1	28	64.5 <tbody> </tbody>
BBBB	31/1/2017	22,029 <tbody> </tbody>	Store1	31	710.6129 <tbody> </tbody>
BBBB	28/02/2017	2,500 <tbody> </tbody>	Store1	28	89.28571 <tbody> </tbody>

<tbody>
</tbody>

 

[louisH]

Hi,

In column "No of Days per month":

=DAY(EOMONTH("EOMDate",0))

Replace "EOMDate" with the matching cell

Or if EOMDate is already the end of the month, just do :

=DAY("EOMDate")