Hi Steve,

Thanks for the help, but I am confused of how to use the
subtotal function. For instance, what is this:
TotalList:=Array(8, 9, 10, _
11, 12, 13, 14, 15, 16, 17, 18)

Is there a way to replace those values b/c my C to F
columns will constantly change, i.e. it might be C to Z
next time? Also, I have to find more Subtotals and then a
Grand Total. How can I use the previous subtotal values to
find the grand total?

Thanks.

Will this work well with macros?


-----Original Message-----
LC,

Excel has a great SubTotal function under the Data menu.
Check it out.
I think it will do everything that you are looking for.

Once you have your data sorted by pet type, the function
will create
subtotal lines per your criteria.

steve

"LC" wrote in 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



.