all subtotals have summary except one

Posted to microsoft.public.excel.programming

SharonInGa[_2_] SharonInGa[_2_] is offline

external usenet poster

Posts: 14

all subtotals have summary except one

My user wants to see the detail for all subtotal categories except for one,
which she wants to see the summary data only.

Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(3, 4, 5,
6, 7, _
' 8, 9), Replace:=True, PageBreaks:=False, SummaryBelowData:=True
' Range("A1:I1").Select
' ActiveWorkbook.Save

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
subtotals showing 0 in summary level// 2 subtotal levels	KM	Excel Discussion (Misc queries)	2	July 12th 08 10:46 PM
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug)	AndyCotgreave	Excel Discussion (Misc queries)	3	October 24th 07 11:32 AM
multi group with summary above with 1 overall summary line below	Freddy	Excel Discussion (Misc queries)	2	November 7th 05 03:30 PM
multi group with summary above with 1 overall summary line below	Freddy	Excel Discussion (Misc queries)	1	November 1st 05 08:50 PM
Problem with nested subtotals, placing secondary subtotals BELOW .	Dawn Cameron	Excel Discussion (Misc queries)	1	June 3rd 05 10:13 PM

All times are GMT +1. The time now is 12:15 AM.

Menu

About Us