VBA to automatically duplicate a cell every minute

Hello,

I have a macro that automatically shift cells up 1 spot and deletes the first cell in the series when a new cell is filled at the bottom. Allowing only a certain number of cells but always having the most relevant data.

The code is :

Please Login or Register  to view this content.

However, I have data that gives me the most current currency exchange price for the Eur/Usd and I wanted to have that data automatically populate the last cell in my series. However if I use a formula such as (=b2) the formula gets
erases as soon as all the cells shift up. I want to have the price update once every minute and have the most recent data continually fed into my series.

Can anyone help with this?