Thread: How do I copy subtotaled data without underlying details in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diletto Diletto is offline
external usenet poster
  
Posts: 1
Default How do I copy subtotaled data without underlying details in Excel
I have a large sheet of data that I have subtotaled. I am trying to copy
just the top layer over to a new worksheet. HOwever, it pulls all the data
below the totaled line. What am I doing wrong?

I am on Excel 2007 on Windows XP.
Reply With QuoteReply With Quote