Hi,

I have a large workbook of sales data. It is broken down into weekly sales
by number of sales and dollar value. So A&B are one week, and C&D are the
next week and so forth.

My last column I need to average the number of sales and the dollar value of
sales for the last five weeks. Is there an easier way to create formulas
every week than manually creating formulas? Is there a formula I can use to
reference the five specific cells I need or VBA?