Subtotal duplicate

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!
 
R

ryguy7272

Data > Pivot Table and Pivot Chart.

Place Gl andf RL in the 'Rows' area. Place AMT int the 'Data Items' area.
Finally, double-click GL > Subtotals > None.

HTH,
Ryan---
 
D

DanaK

Thank you, Ryan, but I've tried a pivot table & it won't work in this
instance. I need a clean list of subtotals to be used 8 different ways in the
same macro. And ever since I got MS 2007, I've had trouble using pivot
tables. One of the areas I wish they had not changed!
DanaK
 
R

ryguy7272

Maybe this would work:
Data > Subtotals > At each change in RL and Add Subtotal to AMT. Then,
click OK.
Then, you can group the data or leave it ungrouped.

Good luck,
Ryan--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top