Hi,

I created a macro to sort records, obtain a sub total then a grand total.
Easily done when creating a macro using the SubTotal function but to run the
macro for a new sheet holding different row count by row label, the subtotal
occurs at the wrong row break. I don't use VBA in Excel much but need a
simple way to do the following:

Name Number

Mark 1
Mark 1
Mark 1
Sub Total 3

Dan 2
Dan 2
Dan 2
Sub Total 6

Joyce 3
Joyce 3
Joyce 3
Sub Total 9

If I use the macro to run the following, it breaks it as:

Mark 1
Mark 1
Mark 1
Sub Total 3

Mark 1
Sub Total 1

Thanks

Norm