Hi all,

Thanks for the replies all were very useful I ended up using JE
McGimpsey formula as it does exactley what i wanted, the things is the
value E7 changes when you want to copy and paste so moving to E8, E9
and so on, which is what i wanted. Thanks for the help guys very much
appreciated,

:)
Motty.


--
Motty
------------------------------------------------------------------------
Motty's Profile: http://www.excelforum.com/member.php...o&userid=29233
View this thread: http://www.excelforum.com/showthread...hreadid=490551