Subtotals
 

I have a very large spreadsheet for which I have created subtotals. How can
I copy only the totals without all the detail to another spreadsheet?

Subtotals
 

Minimize the subtotals using the minus buttons to the left, once you have it
as you want, select the whole visible range that you want, press F5, click
special and select visible cells only, click OK and copy and paste it



--
Regards,



Peo Sjoblom

"MLShef" wrote in message
...
I have a very large spreadsheet for which I have created subtotals. How
can
I copy only the totals without all the detail to another spreadsheet?

Subtotals
 

thank you so very much. that will be very helpful

"MLShef" wrote:

I have a very large spreadsheet for which I have created subtotals. How can
I copy only the totals without all the detail to another spreadsheet?