Hermione9908
New Member
- Joined
- Jun 28, 2022
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hello,
I have a task to generate a sheet containing following headers : Part Number, Quantity, Date
The quantity to be produced is given in one more sheet and that quantity needs to be distributed in that particular month.
For example:
In the vba code, it has to refer the particular month; consider june month. The quantity for june month is 12. So 12 should be distributed in that june month. The output should be as shown in the right most image. The 3 columns should be updated as shown. The dates needs to be divided for that month and the quantity should match the actual quantity.
I want to use a generalized code for all the months and all the output should be in same format as right image.
How to do this with vba code in excel?
Please help.
I have a task to generate a sheet containing following headers : Part Number, Quantity, Date
The quantity to be produced is given in one more sheet and that quantity needs to be distributed in that particular month.
For example:
In the vba code, it has to refer the particular month; consider june month. The quantity for june month is 12. So 12 should be distributed in that june month. The output should be as shown in the right most image. The 3 columns should be updated as shown. The dates needs to be divided for that month and the quantity should match the actual quantity.
I want to use a generalized code for all the months and all the output should be in same format as right image.
How to do this with vba code in excel?
Please help.
