Hm...

Hi Dave,

Thanks for still trying to follow my "confusion"! :o))
Actually, I do not want to set Subtotals starting from a BASEDATA-set.
On the contrary ...

My starting point is a dataset which IS ALREADY STRUCTURED as IF the
"Subtotals-procedure" has been applied (has no formulas, is just a dump
with values Bold /Not Bold)
======= but the outlines/groupings are missing !!!!
================= it are those which i would like to set!
(though NOT via Subtotals as my dataset is already laid-out/summed like
that & i do not want to do it twice
; on top of it I would not be able to do it as my Columns: Category,
Product Group, Quality are missing )

My Starting point is therefor a Column B (like "Price")

-formatted (BOLD vs NOT BOLD):
If you imagine that Column "Price" inherits the Boldness of all
Subtotals (from Column A,B&C)
(Bold cells in column Price will be then in this example:
row:4,7,8,10,14,15,16,21,22,23,24 (25,26)
==== This is my SIGE_STARTDATA!

On this SIGE_STARTDATA (being in Column B) I wish it could be possible
to set the same groupings ....

What you think????


Do you understand why I never had ambition to become a teacher?! :o)))
Sige





Dave Peterson wrote:
Oh, my.

I think I'd trash all that other stuff and just record a macro when I did the
all the data|subtotals.

Then come back and wipe out those extra grand totals lines. They're at the
bottom, just go up from the last cell in column A and delete/clear contents.

with activesheet
.cells(.rows.count,"A").end(xlup).offset(0,-1).resize(2).entirerow.delete
end with

By using the built in functions, you'll even get code that makes sense and can
be modified <vbg.


Sige wrote:

Hi Dave,
I'll explain it differently:

Imagine: (this BASEDATA to be pasted in A1)
Category Product Group Product Quality Price
Food Apple 1 1
Food Apple 1 1
Food Apple 2 1
Food Apple 2 1
Food Orange 1 2
Food Orange 2 2
Food Orange 2 3
Food Orange 2 3
Fuel Petrol 1 5
Fuel Petrol 1 6
Fuel Petrol 1 7
Fuel Petrol 1 8

Now: (with Summary below data checked, Replace current subtotals
un-checked)
Step 1: make SUBTOTALS: at each change in "Category" use function
"sum" add subtotal to "Price"

Step 2: make SUBTOTALS: at each change in "Product Group" use function
"sum" add subtotal to "Price"

Step 3: make SUBTOTALS: at each change in "Product Quality" use
function "sum" add subtotal to "Price"

You get exactly the lay-out of the data I would like to achieve! (with
exception of 2 Grand Totals too many)

If you imagine that Column "Price" inherits the Boldness of all
Subtotals (from Column A,B&C)
(Bold cells in column Price will be then in this example:
row:4,7,8,10,14,15,16,21,22,23,24 (25,26)
==== This is my SIGE_STARTDATA!

On this SIGE_STARTDATA (being in Column B) I wish it could be possible
to set the same groupings .... as if started with the BASEDATA and
applied the Subtotal-procedure 3 times on it.

Hope this made it clearer ... Sige

--

Dave Peterson