Copy & Paste Group Outline without Detail

T

teknovision

Hi all!

I have a very long list of data that is Grouped in about 54 groups.

I would like to copy and paste the group header information without th
detail, any ideas?

Cheers,

Phi
 
F

Frank Kabel

Hi
try the following:
- collapes the data range
- select the range
- hit F5, click 'Special'
- choose 'Only visible cells'
- copy the data
- paste the data
 
Top