Excel 2016 trying to replicate Bubtotal Outline with Top Label / Bottom Sum - and details from nect row

[Tesla]

Column A is sorted by a group of items
Column B has serial numbers in the group

Desired
NameOfGroup item
serial 1
serial 2
serial 3
Sum of Name of Group subtotal ColG Subtotal ColH

Note how ColumnB items fall under the title per group reducing the need to view Column B
Nice and compact.

Can this be done without a script?

 

[cyrilbrd]

Create a pivot table.
You may choose to add a slicer as well with the name of the group as a target thus allowing you to dynamically change the pivot scope.

 

[Tesla]

Customer wants in in a GroupBy format with a lot of customized formatting.
Perhaps the GroupBy with a set of VBA will do the trick.
The plan is to put this code into MSAccess, read SQLServer data and output the Excel with remote automation.
Around 200 custom tabs that will run as a batch job early mornings.
Will search now for how to take specific groupby results and add formatting.
Thanks for the feedback, the Pivot might be a good solution for others.