Thread: how do i copy the subtotal lines only without the details?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default how do i copy the subtotal lines only without the details?
Collapse the table to show just the subtotals
Select the range to copy
Edit|goto (or ctrl-g or F5)
Visible cells only

copy and paste elsewhere.

jimmysyf wrote:

--

Dave Peterson
Reply With QuoteReply With Quote