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
|