Rolling Monthly Amounts to Annual Monthly Amounts
 

I have a spreadsheet that reports sales on a rolling monthly basis: Aug 2005
- Jul 2006 this month, Sept 2005 - Aug 2006 the next month, and so on.

I need to create a annual report by Jan - Dec using the rolling monthly data
each month.

Want to enter amounts into the rolling monthly report and have the same
information on the annual report.

Is this done by a VLOOKUP function? What formula would I use? Need to
help!!!

--
RV