Hi Everyone,
I am looking for a VBA solution for the problem described below but I couldn't figure it out. Any help would be great!
The "Large Number" column and the "Component" column are the input and they are all integers. I was wondering if there is a VBA solution to "break down" the value in column "Large Number" into a number of smaller components based on the value in column "Component". The smaller integers should have variations in their sizes rather than integers closed to the quotient of Large Number and Component, and they will need to add up to the Large number. Thanks.
The actual table has quite a few more rows than the two rows shown below.
Table with Input
<tbody>
</tbody>
Table with Output
<tbody>
</tbody>
I am looking for a VBA solution for the problem described below but I couldn't figure it out. Any help would be great!
The "Large Number" column and the "Component" column are the input and they are all integers. I was wondering if there is a VBA solution to "break down" the value in column "Large Number" into a number of smaller components based on the value in column "Component". The smaller integers should have variations in their sizes rather than integers closed to the quotient of Large Number and Component, and they will need to add up to the Large number. Thanks.
The actual table has quite a few more rows than the two rows shown below.
Table with Input
Large Number | Component |
375 | 3 |
450 | 6 |
<tbody>
</tbody>
Table with Output
<tbody> </tbody> |
<tbody>
</tbody>