After you use data|Subtotals, you can use the outlining symbols on the left hand
side to hide the details.

Select the range to copy
Edit|goto|Special|visible cells only

Copy and paste to the new location.

via135 wrote:

how can i get a list of subtotals?
-via135

--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=499188

--

Dave Peterson