When I do this, it's usually with subtotals, but if you add a unique text to
your group lines (such as "Total"), you can add an autofilter and filter down
on your unique text. You can easily copy and paste filtered data without
getting all the lines in between.

"Aidan" wrote:

I'm trying to paste grouped information that has been collapsed and I just
want to see the collapsed data. However it is expanding all the data. Is
there any way of just seeing the collapsed data only? I have tried all the
paste special options too.


Thanks,


Aidan