Classic Duct and Fabshop had the ACS Report Groups feature. This feature has been added to Advanced Duct in version 4.1.1 and is now called Report Groups. Users can setup groups, add catalog groups to them and get a single line export to excel for those groups.
Notes:
You will need support assistance to add the needed tabs to your company specific spreadsheet
The group totals are static so formulas can be created for them to other sheets within your template
Setting up Report Groups
Navigate to Configuration and then to the Central Options tab on the left
Find the Report Groups section below
Click New button and title your Report Group
Continue adding Report Groups (items are added within the Catalog)
Navigate to Central Data and then select the catalog group desired to assign to a Report Group
Click Edit Group in the top ribbon menu
Click the Select button in the Report Groups section and pick the desired Group
Continue to assign Report Groups to your Catalog Groups
Viewing the Report Groups in Excel
Run the QS Simple Recap or Duct Summary
View the two Report Group tabs
Static_RG tab will have the Report Groups in the same location ALWAYS
Build formulas linking to this sheet only
Dynamic_RG tab will remove the blank lines between Report Groups
Do not build formulas linking to this sheet