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)

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