close
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 quot;Totalquot; which is located in column
A.
Thank you.
全站熱搜
留言列表
