On Sheet 1 I have:
A row of consecutive monthly dates (Jan-14, Feb-14, Mar-14, Apr-14 etc.) - let's call them A1-Z1
A row below with Sales figures for each month (1,2,3,4,5 etc.) - let's call them B1 - Z1
On Sheet 2 I have:
A row of dates which represent different period end dates which...