Never pastes in right line. Nearest number to number in a given cell.

Thanks for that, I can see that I mixed up in a number of places.

I have loaded the code you supplied, and have attached file for you to see the following.

1. When putting in account 1 the code insert a line but leaves it blank? Account 1 is
using so I would not need to add them but i can not see why?

2. When putting in a new highest number 10074, it placed it on row 39 and not on
row 18, 10073 is on line 17, 9988 is on line 38.

Thanks again for your support.....