Good afternoon,
In the attached table, is possible to use Macro to add one empty row after the row which includes “Total” and compute the sum function for Grand Total which is equal to the sum of rows containing “Total”?
Thanks.
BI 2001 123 81 340205.38
COLL 2001 2
COMP 2001 1
PD 2001 304 4 3901
PIP 2001 154 43 33098.45
UM 2001 46 2 4000
Totals 630 130 381204.83
BI 2002 345 249 867863.56
COLL 2002 23
COMP 2002 3
PD 2002 799 27 37800
PIP 2002 482 273 274405.93
UM 2002 77 32 64500
Totals 1729 581 1244569.49
BI 2003 339 323 856015.39
COLL 2003 46
COMP 2003 8
PD 2003 1074 352 507179.61
PIP 2003 607 572 836501.82
UM 2003 81 77 154000
Totals 2155 1324 2353696.82
Grand Total
In the attached table, is possible to use Macro to add one empty row after the row which includes “Total” and compute the sum function for Grand Total which is equal to the sum of rows containing “Total”?
Thanks.
BI 2001 123 81 340205.38
COLL 2001 2
COMP 2001 1
PD 2001 304 4 3901
PIP 2001 154 43 33098.45
UM 2001 46 2 4000
Totals 630 130 381204.83
BI 2002 345 249 867863.56
COLL 2002 23
COMP 2002 3
PD 2002 799 27 37800
PIP 2002 482 273 274405.93
UM 2002 77 32 64500
Totals 1729 581 1244569.49
BI 2003 339 323 856015.39
COLL 2003 46
COMP 2003 8
PD 2003 1074 352 507179.61
PIP 2003 607 572 836501.82
UM 2003 81 77 154000
Totals 2155 1324 2353696.82
Grand Total