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!
<tbody>
</tbody>
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 |
<tbody> </tbody> | Store1 | 31 |
<tbody> </tbody> | ||
AAAA | 28/02/2017 |
<tbody> </tbody> | Store1 | 28 |
<tbody> </tbody> | ||
BBBB | 31/1/2017 |
<tbody> </tbody> | Store1 | 31 |
<tbody> </tbody> | ||
BBBB | 28/02/2017 |
<tbody> </tbody> | Store1 | 28 |
<tbody> </tbody> |
<tbody>
</tbody>