Dave,
that was it, many thanks!
Regards,

H.G. Lamy

"Dave Peterson" wrote in message
...
You can copy the visible cells.

Show just the subtotals
select the range to copy
Edit|goto (or F5 or ctrl-g)|special|visible cells only

Then edit|copy
and paste where you want.



"H.G. Lamy" wrote:

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

--

Dave Peterson