Copy & Paste Group Outline without Detail

  • Thread starter Thread starter teknovision
  • Start date Start date
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
 
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
 
Back
Top