excel and reuters

player · January 30th, 2012, 8:01 am

Im currently getting data from reuters into excel. It is a live feed and everytime there is an new trade an extra row gets printed into excel. My question is is there a way that after say 10 rows have come up the oldest row gets deleted the rest of the list is moved up/down and the latest row then gets printed....So I will always have a maximum of n ( in my example 10)rows (if that makes sense)

rmax · January 30th, 2012, 8:25 am

Call a sub routine on the update event so that it counts the rows and moves the data up a row if the rowcount >n