subtotal question-How can I have a pure "subtotal" only worksheet?

I did a subtotal function. I was in trouble of extracting just those cells containing subtotals without copying those detailed cells.

How can I have a pure "subtotal" only worksheet?

Thank you.

How about pivot table on the original data. That can sum.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wonderdogs828" <[email protected]>
wrote in message
news:[email protected]...
>
> I did a subtotal function. I was in trouble of extracting just those
> cells containing subtotals without copying those detailed cells.
>
> How can I have a pure "subtotal" only worksheet?
>
> Thank you.
>
>
> --
> wonderdogs828
> ------------------------------------------------------------------------
> wonderdogs828's Profile:
http://www.excelforum.com/member.php...o&userid=30086
> View this thread: http://www.excelforum.com/showthread...hreadid=497703
>