Klartigue
03-27-2012, 03:17 PM
See the excel sheet attached.
The first sheet, named data, has my data.
On the second sheet, named tracking, i would like to track the 6 month increase or decrease in yield. So if you go the tracking sheet, as you see in cell B3, i have B3-B2 from the data sheet. However, If i insert a new date on the data sheet in cell B2(while everything else shifts down one), the formula on the tracking sheet shifts down even if I use absolute values. Is there a way to create a rolling formula so everytime i enter new data in row B2 on the data sheet, the tracker calculates that and does not follow the cells it was tracking previously?
Basically, for the most recent 6 months, i would like to caculate the difference between each day. And have this be a rolling calculation so it updates automatically.
Thanks for the help!
The first sheet, named data, has my data.
On the second sheet, named tracking, i would like to track the 6 month increase or decrease in yield. So if you go the tracking sheet, as you see in cell B3, i have B3-B2 from the data sheet. However, If i insert a new date on the data sheet in cell B2(while everything else shifts down one), the formula on the tracking sheet shifts down even if I use absolute values. Is there a way to create a rolling formula so everytime i enter new data in row B2 on the data sheet, the tracker calculates that and does not follow the cells it was tracking previously?
Basically, for the most recent 6 months, i would like to caculate the difference between each day. And have this be a rolling calculation so it updates automatically.
Thanks for the help!