How to set up a repeating macro to sum values in Excel2000?

[crankypants in Washington]

I need to sum a varying number of values on a blank row which exists at the
footing of each group of values to be summed. My problem is that I don't
know how to get Excel 2000 to realize the formula needs to be RELATIVE to
each successive data group, throughout the entire worksheet. I feel sure
that Excel must be capable of this, if I could just show it how. I can embed
the leading cell of each blank summary row with a particular value, to ease
the locating of where the summation process results need to be put. Any help
would be greatly appreciated, as this process takes me several hours each
time I am saddled with this task. Thanks to anyone who can answer this!

 

[Dave F]

Go to Data--Subtotals and follow the instructions in the dialogue box.

Dave

 

[crankypants in Washington]

I need to CREATE A MACRO which would sum a varying number of values on a blank row which exists at the
footing of each group of values to be summed. My problem is that I don't
know how to get Excel 2000 to realize the formula needs to be RELATIVE to
each successive data group, throughout the entire worksheet. I feel sure
that Excel must be capable of this, if I could just show it how. I can embed
the leading cell of each blank summary row with a particular value, to ease
the locating of where the summation process results need to be put. Any help
would be greatly appreciated, as this process takes me several hours each
time I am saddled with this task. Thanks to anyone who can answer this!