Hi,

I very much like the idea of adding subtotals together.
But how is it possible using VBA?

Oh, I'm sorry, I'm a little new to the Subtotal function.

Thanks alot.
-----Original Message-----
It looks that you only have to use the Subtotals Command
at the Data Menu. maybe you need to add column names on
row 1,then you can select which field change will make
the
insertion of row with subtotals.

The last question, will depend on where is the
information, that allow you to question if a pet has
white
hair or whatever., So it is difficult to say whitout
knowing the kind of formulas.

But you can include subtotals on areas that already have
subtotals and it function very well, maybe it is the
solution you are looking for



Francisco Mariscal
fcomariscal at hotmail dot com


-----Original Message-----
Hi,

I feel like I have confused you before and I would like
to
clear some things up.
My previous code was an attempt to do this

Lets say:
A B C D E F G H I J
1 Pets cats 1 23 2 4 23 45 43 23
2 Pets cats 3 4 2 5 67 23 23 23
3 Pets dogs 2 2 3 4 34 23 23 23
4 Pets dogs 4 5 13 4 34 23 23 23

Ok, I would like to insert a new row for the totals of
row
1 and 2 and insert another row for the totals of row 3
and
4 and then a new row for totals of all the rows. I have
to
use a formula b/c I want the totals to update if the
values were change for cats in either column C to J.

Goal:

A B C D E F G H I J
1 Pets cats 1 23 2 4 23 45 43 23
2 Pets cats 3 4 2 5 67 23 23 23
total for cats...
3 Pets dogs 2 2 3 4 34 23 23 23
4 Pets dogs 4 5 13 4 34 23 23 23
total for dogs
total for Pets

After all this is done, let's say I want to insert a new
row for the total of all cats with white hair within the
rows 1 and 2. Will this mess up the other formulas?

Ok, I hope this clears everything up!
Thank you very much,
LC

.

.