I am trying to create some vba code to update a time series down a column, and linking to the same absolute cell every time for the data that corresponds with the time series. Eg, I would update the sheet occasionally, with dates in column A, and column B would have the value currently calculated in some other cell (E1). So when I go to update this for today, the code would go down column A and find the next blank row...insert a formula for today's date +today(), tab over to column B, and then link to the static cell I choose (E1). Finally, I'd like to paste value the two cells I just modified so that next time I open the doc the data reflects the old date from the +today() formula, and the old value contained in E1. Can somebody help me write this code? I just cant figure it out. thanks