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