Hi All,
In the below example, I want to add each days splitted amount in Amt 3 and reconcile with Amt 1 & Amt 2, say for example, For Monday, if we add first 4 rows in Amt 3, we get 2000 which is in Amt 2 and if we add next 3 rows of Monday , we get 1000 which is in Amt 1. Anyone's help with any VBA code will be appreciated.
<colgroup><col><col span="4"><col></colgroup><tbody>
</tbody>
Thanks you in advance
In the below example, I want to add each days splitted amount in Amt 3 and reconcile with Amt 1 & Amt 2, say for example, For Monday, if we add first 4 rows in Amt 3, we get 2000 which is in Amt 2 and if we add next 3 rows of Monday , we get 1000 which is in Amt 1. Anyone's help with any VBA code will be appreciated.
Days | Amt 1 | Amt 2 | Amt 3 | Total | Example |
Monday | 1000 | 2000 | 500 | 2000 | 500 + 500 + 500 + 500 |
Monday | 1000 | 2000 | 500 | 2000 | 500 + 500 + 500 + 500 |
Monday | 1000 | 2000 | 500 | 2000 | 500 + 500 + 500 + 500 |
Monday | 1000 | 2000 | 500 | 2000 | 500 + 500 + 500 + 500 |
Monday | 1000 | 2000 | 250 | 1000 | 500 + 250 + 250 |
Monday | 1000 | 2000 | 250 | 1000 | 500 + 250 + 250 |
Monday | 1000 | 2000 | 500 | 1000 | 500 + 250 + 250 |
Tuesday | 2900 | 1100 | 750 | 2900 | 750 + 750 + 500 + 450 +450 |
Tuesday | 2900 | 1100 | 750 | 2900 | 750 + 750 + 500 + 450 +450 |
Tuesday | 2900 | 1100 | 600 | 1100 | 600 + 500 |
Tuesday | 2900 | 1100 | 500 | 1100 | 600 + 500 |
Tuesday | 2900 | 1100 | 500 | 2900 | 750 + 750 + 500 + 450 +450 |
Tuesday | 2900 | 1100 | 450 | 2900 | 750 + 750 + 500 + 450 +450 |
Tuesday | 2900 | 1100 | 450 | 2900 | 750 + 750 + 500 + 450 +450 |
Wednesday | 1500 | 2500 | 750 | 1500 | 750 + 750 |
Wednesday | 1500 | 2500 | 750 | 1500 | 750 + 750 |
Wednesday | 1500 | 2500 | 1000 | 2500 | 1000 + 1000 + 250 +250 |
Wednesday | 1500 | 2500 | 1000 | 2500 | 1000 + 1000 + 250 +250 |
Wednesday | 1500 | 2500 | 250 | 2500 | 1000 + 1000 + 250 +250 |
Wednesday | 1500 | 2500 | 250 | 2500 | 1000 + 1000 + 250 +250 |
Thursday | 2250 | 2750 | 1000 | 2250 | 1000 + 250 +1000 |
Thursday | 2250 | 2750 | 750 | 2750 | 750 + 2000 |
Thursday | 2250 | 2750 | 250 | 2250 | 1000 + 250 +1000 |
Thursday | 2250 | 2750 | 2000 | 2750 | 750 + 2000 |
Thursday | 2250 | 2750 | 1000 | 2250 | 1000 + 250 +1000 |
Friday | 8450 | 1550 | 450 | 8450 | 450 + 2000 + 3000 + 1000 + 2000 |
Friday | 8450 | 1550 | 550 | 1550 | 550 + 1000 |
Friday | 8450 | 1550 | 2000 | 8450 | 450 + 2000 + 3000 + 1000 + 2000 |
Friday | 8450 | 1550 | 3000 | 8450 | 450 + 2000 + 3000 + 1000 + 2000 |
Friday | 8450 | 1550 | 1000 | 1550 | 550 + 1000 |
Friday | 8450 | 1550 | 1000 | 8450 | 450 + 2000 + 3000 + 1000 + 2000 |
Friday | 8450 | 1550 | 2000 | 8450 | 450 + 2000 + 3000 + 1000 + 2000 |
<colgroup><col><col span="4"><col></colgroup><tbody>
</tbody>
Thanks you in advance