Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub Total Report Appearance
How can I get the Report appearance using Sub Total to do the following?
1. Label appears indented 2. Label appears only one time for all of the records in a sub total? 3. Skip one line between each sub total ------------------------------------------------ Original Sub Total Appearance ------------------------------------------------ SUB-TOT TYPE Name Assets Customer One Assets Customer Two Assets Customer Three Assets Sub Total Equity Customer One Equity Customer Two Equity Sub Total ---------------------------------------------- Wish List Outcome ---------------------------------------------- SUB-TOT TYPE Name Assets Customer One Customer Two Customer Three Assets Sub Total ##### Equity Customer Two Customer Three Equity Sub Total ##### Worksheets("Sheet1").Activate Selection.Subtotal GroupBy:=1, Function:=xlSum, _ TotalList:=Array(4, 5, 6, 7, 8, 9) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub Total Report Appearance
Instead of using the subtotals feature, you could create a pivot table,
and set the row headings to include a blank line after each heading. There are instructions and links for pivot tables on Jon Peltier's site: http://peltiertech.com/Excel/Pivots/pivotstart.htm SharonInGa wrote: How can I get the Report appearance using Sub Total to do the following? 1. Label appears indented 2. Label appears only one time for all of the records in a sub total? 3. Skip one line between each sub total ------------------------------------------------ Original Sub Total Appearance ------------------------------------------------ SUB-TOT TYPE Name Assets Customer One Assets Customer Two Assets Customer Three Assets Sub Total Equity Customer One Equity Customer Two Equity Sub Total ---------------------------------------------- Wish List Outcome ---------------------------------------------- SUB-TOT TYPE Name Assets Customer One Customer Two Customer Three Assets Sub Total ##### Equity Customer Two Customer Three Equity Sub Total ##### Worksheets("Sheet1").Activate Selection.Subtotal GroupBy:=1, Function:=xlSum, _ TotalList:=Array(4, 5, 6, 7, 8, 9) -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Monthly Total report based on 2 or 3 criteria. VBA or Formula | Excel Discussion (Misc queries) | |||
appearance of a concatenated value | Excel Worksheet Functions | |||
help need to total a months worth of worksheets into one report | New Users to Excel | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Total Line in Report | Excel Programming |