Page 1 of 1

excel and reuters

Posted: January 30th, 2012, 8:01 am
by player
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)

excel and reuters

Posted: January 30th, 2012, 8:25 am
by rmax
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