I have a worksheet with data that has a group and outline in it. The group
and outline rolls up so that the groups contain subtotals. I want to copy
the subtotals from the group and outline and paste them into another
worksheet with just the subtotals (not with the rest of the rolled up data).
I cannot copy and paste just the subtotals, the data expands everytime I
paste it.