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)