View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jgorman
 
Posts: n/a
Default From Monthly to Quarterly Numbers


I have many years of by month data listed in columns. I would like to
start a new sheet that adds 3 months of data into a quarterly column.
That is it would add the the first 3 months of a year for Q1, then take
months 4,5,6, for Quarter 2, months 7,8,9 for Q3 etc. and be able to
move the data to the new sheet automaticaly. Any ideas much
appreciated.
Thanks
Jake


--
jgorman
------------------------------------------------------------------------
jgorman's Profile: http://www.excelforum.com/member.php...o&userid=33081
View this thread: http://www.excelforum.com/showthread...hreadid=528933