View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
H.G. Lamy H.G. Lamy is offline
external usenet poster
 
Posts: 48
Default Copy only visible cells after applying "Subtotals"

Hello,

in an XL-list I need to copy only a block of subtotals to another area,
without the detail rows in between. I believe there once was a command like
"paste only visible cells" (or similar), but I can't find a solution.
Anybody who knows how to do this ?

Thank you in advance,

H.G. Lamy