i see! great, that fits in now, however its just pasting the value into cell R6, not 'inserting' it, so that the previous value in R6 moves to the right, thus keeping all the previuous values in R6 nicely in Row 6... if that makes sense.

I need to insert it so it doesnt copy over the previous value. i need to keep a record....

thnx