Subtotals copy paste
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 |
Subtotals copy paste
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Seebu" wrote: 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 |
All times are GMT +1. The time now is 03:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com