Copying only subtotals
 

In doing DataSubtotals and then clicking on the 2 to show only subtotals,
how do I copy and paste only those subtotals into another spreadsheet without
it pasting in all the data in between? Thank you. Connie

Copying only subtotals
 

Sorry....I found my own answer he
http://www.dailydoseofexcel.com/arch...ubtotals-only/
Excellent!

"Connie Martin" wrote:

In doing DataSubtotals and then clicking on the 2 to show only subtotals,
how do I copy and paste only those subtotals into another spreadsheet without
it pasting in all the data in between? Thank you. Connie