View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yagna yagna is offline
external usenet poster
 
Posts: 12
Default macro to do subtotal by eachqtr in calendar year

Hi MVPs,

I have written a macro to calculate the budget each month which inserts row,
the lines in the excel based on the date range given by month wise. I need
now to calculate the quarterly subtotal for the months given in teh date
range.

for eg;) date range 01-jan-09 to 31-mar-09
Jan-09 1000
Feb-09 1000
Mar-09 1000
Qtr 1 09 3000

Thanks for your replies.