How do I copy an outline w/ subtotals & paste just the subtotals

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.

Use those outlining symbols to show just what you want to copy.

Then select that range
edit|goto|special
visible cells only

copy
and paste to the new location.

av wrote:
>
> 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.

--

Dave Peterson