agnesz
05-04-2009, 07:03 AM
The attached report is a dynamic business recap which will have sections either added or removed on a weekly basis.
Once the columns are added/deleted I'd like the recap to subtotal at each change in "region name" column A.
The subtotals should be as follows:
Sum for TY, LY, PL
and % changes in TY Pen, % LY, % Pln (these 3 are not critical to have in there)
After the subtotal processes and creates a grand total row, I'd like any rows that are totally blank to be hidden.
Thanks as always, you guys rock.
:dunno
Once the columns are added/deleted I'd like the recap to subtotal at each change in "region name" column A.
The subtotals should be as follows:
Sum for TY, LY, PL
and % changes in TY Pen, % LY, % Pln (these 3 are not critical to have in there)
After the subtotal processes and creates a grand total row, I'd like any rows that are totally blank to be hidden.
Thanks as always, you guys rock.
:dunno