Hi,
I'm not sure if I understand your layout correctly but try selecting
your range of subtotals & then pressing [alt+'] to limit the selection
to visible cells.
Or edit - go to - special - visible cells only.
Then try the copy & paste special as values. Does this help?

Another option may be to use John Walkenbach's "copy multiple
selection" http://j-walk.com/ss/excel/files/copymult.exe sourced from
http://j-walk.com/ss/excel/files/developer.htm

Hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=501982