I have a two sheet workbook, simply put. There is a percentage of work done calculated on sheet1!C46. This is calculated from check marks in C1-C45, when part of a project is completed a check mark is placed raising the percentage in C46. On Sheet two there is simply a row (C3-Q3) with each month in the mmm-yy format. Right now Sheet2!C4 which is directly below the corresponding month (Sep-13) has "=sheet1!C46" and is perfect. What I need is, on the first of each month the value in the previous month must Freeze/Save, and the running percentage from sheet1:C46 needs to move one column to the right into the next months column.
Would be happy to answer any more questions, or provide a template if needed. Thank you!!