| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set up a repeating macro to sum values in Excel2000?
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to set up a repeating macro to sum values in Excel2000?
Go to Data--Subtotals and follow the instructions in the dialogue box.
Dave -- Brevity is the soul of wit. "crankypants in Washington" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to set up a repeating macro to sum values in Excel2000?
"crankypants in Washington" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro fails to produce Category Name and Percentage values - Pie C | Charts and Charting in Excel | |||
| Repeating a Macro For Each Selected Worksheet | Excel Worksheet Functions | |||
| formatting date-time values in macro | Excel Worksheet Functions | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Hybrid Mode
