Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Totals
Hello,
I have a macro that generates a spreadsheet and the data needed automatically. The macro then generates subtotals throughout the spreadsheet. I would then like to have the macro automatically Total these subtotals. Any suggestions on the most efficient method of moving through the spreadsheet and finding the sub-total rows needed and then placing an amount in the Final Total cell -- which would then need to be carried across 50 additional cells in the row (totaling the sub- totals for each column). Any suggestions would be appreciated. Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
Grand Totals with Nested Sub Totals | Excel Discussion (Misc queries) | |||
how to enter totals and sub totals from receipts into excel. | New Users to Excel | |||
Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |