View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
samcham samcham is offline
external usenet poster
 
Posts: 12
Default 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!