G
Guest
I wasn't sure how to word the subject, but in short here's my situation:
I have a worksheet with hundreds of subtotals (that will grow in count
monthly). When I create a subtotal for a given value change, it enters a row
in and then enters a title for the given value change, but that's it (aside
from the totals).
I have 5 columns and to avoid manually updating the values myself, I want to
have them entered automagically
Example (copy table below in Excel to see current format):
Reg Ctry Grp Date Cust Class Prod Score Sales Amount
1 A A Jan-07 P NA NA 1000 100 15000
NA Total 1000 100 15000
1 A A Jan-07 P H Ac 1200 80 16000
H Total 1200 80 16000
Now copy the table below to see what I actually want:
Reg Ctry Grp Date Cust Class Prod Score Sales Amount
1 A A Jan-07 P NA NA 1000 100 15000
1 A A Jan-07 P NA Total 1000 100 15000
1 A A Jan-07 P H Ac 1200 80 16000
1 A A Jan-07 P H Total 1200 80 16000
Is there a magical way to have those values copied down? I need to enter the
data each month, sort it, and then generate the subtotals. When they are all
collapsed, I'd like to be able to see the Reg, Ctry, Grp, etc. for every
subtotal.
My thanks in advance.
Vexed in VanCity,
JCH
I have a worksheet with hundreds of subtotals (that will grow in count
monthly). When I create a subtotal for a given value change, it enters a row
in and then enters a title for the given value change, but that's it (aside
from the totals).
I have 5 columns and to avoid manually updating the values myself, I want to
have them entered automagically
Example (copy table below in Excel to see current format):
Reg Ctry Grp Date Cust Class Prod Score Sales Amount
1 A A Jan-07 P NA NA 1000 100 15000
NA Total 1000 100 15000
1 A A Jan-07 P H Ac 1200 80 16000
H Total 1200 80 16000
Now copy the table below to see what I actually want:
Reg Ctry Grp Date Cust Class Prod Score Sales Amount
1 A A Jan-07 P NA NA 1000 100 15000
1 A A Jan-07 P NA Total 1000 100 15000
1 A A Jan-07 P H Ac 1200 80 16000
1 A A Jan-07 P H Total 1200 80 16000
Is there a magical way to have those values copied down? I need to enter the
data each month, sort it, and then generate the subtotals. When they are all
collapsed, I'd like to be able to see the Reg, Ctry, Grp, etc. for every
subtotal.
My thanks in advance.
Vexed in VanCity,
JCH