Hi to all of you, kindly require to provide me support for a VBA code so that, to match debtor’s amounts based on months. Therefore that the months have a stable row “C4” : “O4” including “Total” column and also the data have stable range “A3500” : “O3595”. The adjusted data I would like to place them (start) from row “A3600”. I present below original data and expected result. Thank you all in advance
Original data
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
4 | MONTH | May | June | July | August | September | October | November | December | Total | |||||
5 | |||||||||||||||
6 | |||||||||||||||
3500 | CODE | DEBTOR | January | February | March | April | May | June | July | August | September | October | November | December | |
3501 | 10120 | CODE 10120 | 12150 | 15250 | 16455 | 11800 | 9856 | 10125 | 7845 | 10274 | 9785 | 17458 | 12147 | 10789 | 143934 |
3502 | 10138 | CODE 10138 | 785 | 1555 | 458 | 325 | 985 | 1458 | 947 | 896 | 712 | 556 | 672 | 596 | 9945 |
<tbody>
</tbody>
Expected result
3600 | CODE | DEBTOR | May | June | July | August | September | October | November | December | |||||
3601 | 10120 | CODE 10120 | 9856 | 10125 | 7845 | 10274 | 9785 | 17458 | 12147 | 10789 | 0 | 0 | 0 | 0 | 88279 |
3701 | 10138 | CODE 10138 | 985 | 1458 | 947 | 896 | 712 | 556 | 672 | 596 | 0 | 0 | 0 | 0 | 6822 |
<tbody>
</tbody>
Last edited: