Move the % calculation one column to the left or right of the subtotaled
column.
HTH,
Gary Brown

"Jesterhoz" wrote:

Hello All,

I have a macro that creates subtotals for a sheet of data. However, I then
insert rows below each subtotal to calculate percentages for each subtotal.
This works fine but afterwards, the grand total includes these percentages in
its figure. So, my grand total is off by a few dollars or cents depending
upon the percentages above it. Does anyone have any suggestions on how to
counter this?

Thanks for your time.

Trevor