J
Jim
I am trying to have Excel carry values from non-subtotaled cloumns to show up
on the subtotal row.
on the subtotal row.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Debra Dalgleish
What values are you trying to show?
Instead of subtotals, you may find it easier, and more flexible, to use
a Pivot Table to summarize the data. There are instructions in Excel's
Help, and Jon Peltier has information and links:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
Instead of subtotals, you may find it easier, and more flexible, to use
a Pivot Table to summarize the data. There are instructions in Excel's
Help, and Jon Peltier has information and links:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
J
Jim
I am trying to show the value of the data on the row above the subtotal line.
Basically the information used to separate the various lines of data. More
than the one reference used to differentiate the data.
Basically the information used to separate the various lines of data. More
than the one reference used to differentiate the data.
D
Debra Dalgleish
There's nothing built in that will show additional data in the subtotal
row. You could manually or programmatically add a formula to the
subtotal row, referencing the cell above.
row. You could manually or programmatically add a formula to the
subtotal row, referencing the cell above.
D
Dave Peterson
How did you get the subtotals?
If you got them via data|subtotal, then you have outlining symbols to the left.
Hide all those detail rows--leaving only the subtotals.
Select those cells you want to add the info to.
But then Edit|goto|special|visible cells only
Say the cell that's active is now B12
type this formula
=b11
(the cell right above)
and hit ctrl-enter to fill all the selected cells with a similar formula.
But you still may want to take a look at that pivottable stuff. It might be
what you want and after an hour or two, you'll never use Data|subtotals again
<vbg>.
If you got them via data|subtotal, then you have outlining symbols to the left.
Hide all those detail rows--leaving only the subtotals.
Select those cells you want to add the info to.
But then Edit|goto|special|visible cells only
Say the cell that's active is now B12
type this formula
=b11
(the cell right above)
and hit ctrl-enter to fill all the selected cells with a similar formula.
But you still may want to take a look at that pivottable stuff. It might be
what you want and after an hour or two, you'll never use Data|subtotals again
<vbg>.