subtotal w/o grand total

[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

 

[new girl]

should i add more explanation

 

[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

 

[new girl]

i'm going to where it only shows the subtotals

 

[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

 

[JMay]

When your view is At the Sub-total level << as you said you are>>
highlight the area you want,
then at the menu Edit, Goto... Click on Special Button, Click on Visible
Cells Only, OK.
Then do your ordinary Copy, change to a new worksheet, then a
Paste-Special-Values.
Esc to unselect highlighted area.
HTH

 

[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

 

[JMay]

"change to a new worksheet"