Y
Yellowbird
Hopefully this makes sense and someone can assist with this relative
newbie's pagebreak/subtotals question.
I've got a worksheet with data as follows:
Type A Type B Total By Location
Location A 0 1 1
Location B 1 4 5
Total By Type 1 5
The report is variable length (both rows and columns) and I want to be
able to create a macro to search for each pagebreak (HPageBreak and
VPageBreak) and insert a subtotal just before (so the subtotal is the
last row and column of each page). Then, on the last page of the
report, have a final Subtotal and Grand Total row and column.
I've searched for ideas and it seems that Data | Subtotals might work,
but I am fairly new to Excel and can't seem to get it to work without
getting a subtotal in every other row, which I don't want.
Can anyone offer a suggestion on a way to do this?
TIA,
Yellowbird
newbie's pagebreak/subtotals question.
I've got a worksheet with data as follows:
Type A Type B Total By Location
Location A 0 1 1
Location B 1 4 5
Total By Type 1 5
The report is variable length (both rows and columns) and I want to be
able to create a macro to search for each pagebreak (HPageBreak and
VPageBreak) and insert a subtotal just before (so the subtotal is the
last row and column of each page). Then, on the last page of the
report, have a final Subtotal and Grand Total row and column.
I've searched for ideas and it seems that Data | Subtotals might work,
but I am fairly new to Excel and can't seem to get it to work without
getting a subtotal in every other row, which I don't want.
Can anyone offer a suggestion on a way to do this?
TIA,
Yellowbird