Thread: How do I copy and paste only the sub-total from a list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default How do I copy and paste only the sub-total from a list
Try this:
Set view to display subtotal rows only
EditGotoCurrent area
EditGotoVisible cells only
Copy/Paste

Regards,
Stefi

€žKlutz€ť ezt Ă*rta:

I have an Excel spreadsheet which consists of data with sub-totals. How do I
copy and paste only the sub-total values to another spreadsheet?
Reply With QuoteReply With Quote