Ok i have managed to get this working but now have trouble picking u
cell values, i.e if the cell that has changed is lets say between I
and M400 then put the corresponding value of row 1 in place of targe
value.

Any thoughts?

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=26636