I have listed all the month's transactions in three columns, date customer and amount.
I have sorted the month's list by customer and sub-totalled it getting the usual "1 2 and 3" choices at the top left of the sub-total page.
I now have 12 of these( one for each month)
I wish to copy the customer totals (No. 2 of the "1 2 and 3") off the sub-total page and on to a new sheet.
However the copy and paste or cut and paste commands take the totals across with all the underlying items that make up those totals, so that I can't get just the 12 monthly totals for each customer, which is all I want.

Please can you tell me how I get excel to just copy across the totals without the underlying items?

Thanks

Phil