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