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)