First, check to see if the outlining symbols have been turned off:
tools|options|view tab

If those columns are missing, I don't think it's possible (well, for me anyway)
to recreate what did the outlining.

Yell at the person who did this to either hide those columns or not delete
them. Then lower your sights <bg and use data|subtotals!



Sige wrote:

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

--

Dave Peterson