Hi

My first post on this forum which has helped me a number of times in the past. I will try to be as accurate as I can.

I have a data feed in an automatically updating cell of which I save all historical values in a column using worksheet_calculate (newest entries are written at the bottom). To prevent the list from growing too large and, only keep the latest data, I want to keep the newest 100 values. So if I want to only keep the latest 10 values of new data in the below column, once value 11 arrives from the feed i'd like for value 1 (first value in the range) to get deleted.

1 - gets deleted once value 11 arrives (assuming you want to keep the latest 10 values)
2 - gets deleted once value 12 arrives (assuming you want to keep the latest 10 values)
3
4
5
6
7
8
9
10
11
12

Any suggestions would be appreciated

Thanks