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

  • Thread starter crankypants in Washington
  • Start date
C

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!
 
C

crankypants in Washington

crankypants in Washington said:
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top