delete data between subtotals

[peterrebsamen]

I would like to delete all data between my subtotals without the
subtotals changing. I tried to collapse the whole sheet and to copy the
then visible data (with paste values only). this did not work. is there
any other way to get rid of data between subtotals? appreciate your
help. please see attachement.

Attachment filename: illustration_1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=446537

 

[Frank Kabel]

Hi
see Peo's response in your original thread

 

[peterrebsamen]

thanks frank. saw peo's answer. works perfectly.