D
DanaK
I have a list of amounts that are attached to 3 separate elements. I need to
have a subtotal on a single line (no levels like in the 'subtotal' function)
for each change in the 3 columns as a whole, then delete the lines that are
not total lines. I need to work this into an existing macro, but I record all
of them & the subtotal function with 3 levels got way too messy. The list is
always a variable length & all 3 columns will have different values. Any
suggestions?
Original list:
A B C D
GL ST RL AMT
602600 01 KC 30.00
602600 01 KC 4.50
602600 00 GA 10.00
602600 00 GA 2.25
602600 04 KB 15.00
602600 04 KB 3.75
702600 04 KB 6.00
602600 04 KE 24.00
602600 04 KE 4.50
602600 04 KM 7.50
List as I would like it to be:
GL ST RL AMT
602600 01 KC 34.50
602600 00 GA 12.25
602600 04 KB 18.75
702600 04 KB 6.00
602600 04 KE 28.50
602600 04 KM 7.50
Any help would be appreciated!
have a subtotal on a single line (no levels like in the 'subtotal' function)
for each change in the 3 columns as a whole, then delete the lines that are
not total lines. I need to work this into an existing macro, but I record all
of them & the subtotal function with 3 levels got way too messy. The list is
always a variable length & all 3 columns will have different values. Any
suggestions?
Original list:
A B C D
GL ST RL AMT
602600 01 KC 30.00
602600 01 KC 4.50
602600 00 GA 10.00
602600 00 GA 2.25
602600 04 KB 15.00
602600 04 KB 3.75
702600 04 KB 6.00
602600 04 KE 24.00
602600 04 KE 4.50
602600 04 KM 7.50
List as I would like it to be:
GL ST RL AMT
602600 01 KC 34.50
602600 00 GA 12.25
602600 04 KB 18.75
702600 04 KB 6.00
602600 04 KE 28.50
602600 04 KM 7.50
Any help would be appreciated!