subtotal w/o grand total

N

new girl

i am runnin windows xp/excel 2002

i am trying to record a macro. they sheet i am on has 10 columns
first, the macro does a subtotal at each change. then, i need to t
take all of the subtotals and move it over to another sheet, leavin
the grand total.

is there any way to tell it to get all of the totals with an exceptio
for the grand total?

there are anywhere from 3 to 8 subtotals depending on which customer
pull the information from
 
A

AlfD

Hi!

How are you copying your subtotals? One at a time? Or by closing dow
the display so it only shows subtotal rows?

Al
 
A

AlfD

OK

If you are copying the subtotal rows they will still be ther
afterwards, since you copied them: you didn't move them. And if yo
didn't copy the Grand Total (which you don't want) it will still b
there in the original list.

What do you want to happen to the original list? If you want th
subtotal lines to disappear, the Data> Subtotals gives you the optio
(check box) to get rid of them. If you want the Grand Totals line t
remain in that sheet, then copy it (before you undo the Subtotals!!!
and paste it into a line below where it was generated.

If I've missed the point, give more detail...

Al
 
B

BrianB

It sems that your macro is inserting the subtotals, which you do no
need later.

Instead of putting them into the current sheet, have the macro put the
in the external sheet
 
Top