Have you tried pivot tables? Can be tedious but as the original table gets
updated so does the result table - totals.

"Elzora" wrote:

I created a grand totals row using autosum and saved it in a macro. My
problem is that when I use the macro on table of different sizes, the grand
totals are always created on the same row number. Is there another way to
get grand totals without using subtotals?