Subtotals copy paste

S

Seebu

Hello,
I would apprecaite providing me a solution to copy and paste the Subtotals
in Excel. Generally if we copy and paste subtotals it will come with all the
details of the Subtotals. I don't want details I need only the Subtotal to
come when I paste. Please help me to solve this issue or advise me any other
fuction/operation with which I can get the subtotals only.

Thanks
 
M

Max

Assuming the table is collapsed to suit
Select the range
Press F5 > Special > Visible cells only > OK
Right-click on the selection > Copy
Then just go to the new sheet > paste
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Additonal info into newly created Subtotal row 1
Can I use the subtotal function while a worksheet is protected? 0
subtotal, match? 10
Excel 2007 - Outline not displaying all nested subtotals 0
How to paste this down? 3
Subtotal 3
Macro Pause to Select range then Subtotal 0
How to make repeating drop-down lists? 2

Top