Hi all, i would like to "SUM" the below numbers using a VBA code which should base on description in col. "AK". In F.1. are the original data and in Sch.2. is the expected result. Therefore that the rows are not stably and are change due to accounts which have movement for each month.
Thanking you in advance
Sch.1.
<tbody>
</tbody>
Sch.2.
<tbody>
</tbody>
Thanking you in advance
Sch.1.
| AK | AL | AM | AN | |
| 546 | TOTAL REVENUE: | -50,555.00 | ||
| 547 | ||||
| 548 | COST OF SALES | 8,150.00 | ||
| 549 | ELECTRICIYT | 3,125.00 | ||
| 550 | WATER SUPPLY | 1,245.00 | ||
| 551 | PRINTING & STATIONERY | 874.00 | ||
| 552 | HEATING & LIGHTING | 2,896.00 | ||
| 553 | REPAIRS & MAINTENANCE | 4,258.00 | ||
| 554 | RATES & LICENSES | 1,368.00 | ||
| 555 | ADMINISTRATION EXPENSES | 2,562.00 |
<tbody>
</tbody>
Sch.2.
| AK | AL | AM | AN | |
| 546 | TOTAL REVENUE: | -50,555.00 | ||
| 547 | ||||
| 548 | COST OF SALES | 8,150.00 | ||
| 549 | ELECTRICIYT | 3,125.00 | ||
| 550 | WATER SUPPLY | 1,245.00 | ||
| 551 | PRINTING & STATIONERY | 874.00 | ||
| 552 | HEATING & LIGHTING | 2,896.00 | ||
| 553 | REPAIRS & MAINTENANCE | 4,258.00 | ||
| 554 | RATES & LICENSES | 1,368.00 | ||
| 555 | ADMINISTRATION EXPENSES | 2,562.00 | ||
| 556 | ||||
| 557 | TOTAL EXPENSES | 24,478.00 | ||
| 558 | ||||
| 559 | NET PROFIT / LOSS | -26,077.00 |
<tbody>
</tbody>
