Subtotal duplicate
 

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

Subtotal duplicate
 

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---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"DanaK" wrote:

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

Subtotal duplicate
 

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


"DanaK" wrote:

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

Subtotal duplicate
 

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

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"DanaK" wrote:

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


"DanaK" wrote:

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