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
|