subtotal loop
 

I have ytd information in columns A-L that are subtotaled by expense
classification. Subotalling is done in Pivot Table. This information is
imported into the spreadsheet via macro. In columns M-P, I have monthly
information that is imported via Vlookup. I tried have the Pivot Table
produce both ytd and monthly results, but I could not get all of the ouput in
columnar data (ie., for years 2006 and 2005).

Trying to find formula that I can incorporate into macro that will allow me
to subtotal the monthly information on the same lines as the ytd information.
Each subtotal line title ends in the word "Total" which is located in column
A.

Thank you.