#1   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
subtotal a range of cells on a different worksheet cheryl Excel Worksheet Functions 0 November 2nd 05 08:37 PM
Subtotal Bug in Excel 2003 GON Excel Discussion (Misc queries) 2 May 10th 05 08:42 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM
Subtotal Question Bill McMichael Excel Worksheet Functions 2 December 29th 04 06:51 PM
Subtotal question Patricia Excel Worksheet Functions 2 November 23rd 04 07:25 PM


All times are GMT +1. The time now is 11:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"