Simple Time Series Update

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

could you send a sample....

Here's an example of what it would look like - dates going down column A and values going down column B. The values would be coming from one cell in the worksheet. Effectively, I'd like to run a macro that would modify both columns on the bottom row. So what it would do is go to the next empty row in column A (the cell below 11/18/13) and insert today's date [+today()], then tab over to the values column and link to the predefined cell in my spreadsheet that has the value I want to collect. Finally, I'd like to paste value these two cells so that when I open it again it has the old values listed in these columns. Does that make sense? Thanks
Column A...........Column B
Date.................Values
11/1/13.............100
11/5/13.............115
11/18/13............95

Thank you so much!!! Knew it'd be simple but I had no idea.