ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   subtotal question (https://www.excelbanter.com/excel-discussion-misc-queries/62883-subtotal-question.html)

wonderdogs828

subtotal question
 

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


Bob Phillips

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

--

HTH

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


"wonderdogs828"
wrote in message
news:wonderdogs828.212wdb_1136325001.7768@excelfor um-nospam.com...

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





All times are GMT +1. The time now is 05:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com