How do I copy only sub-totalled values - without any detail?

P

Parkperson

I am trying to copy only the sub-totalled values (Paste-Values) and eliminate
the detail. How do I just copy the sub-totals?
 
F

Frank Kabel

Hi
- select your range
- hit F5, click 'Special' and choose 'only visible cells'
- now copy+paste
 
Top