Subtotal Group Titles
When using the subtotal function off the Data menu, I would like to add a
title at the top of each section break, as well as on the subtotal line. For
example:
Account Expense Category Amount
EXPENSE CATEGORY: 120 CONTRACT LABOR
01.6000.2000 120 9,896
____________
TOTALS FOR EXPENSE CATEGORY: 120 9,896
EXPENSE CATEGORY: 130 SUPPLIES
01.6000.2510 130 1,376
01.6000.2520 130 6,537
01.6000.2540 130 442
____________
TOTALS FOR EXPENSE CATEGORY: 130 8,355
I have too many of them to add manually. Is there a way to do this quickly
and easily?
Thanks!
|