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 |
All times are GMT +1. The time now is 12:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com