On The other hand the next part I'm battling to complete once the mass copy and paste has run I want One more code which will update column A accordingly this kind of which the Task num from sheet 2 will fill in to each between tasks 2 and 10,000 http://rivonirecruitment.co.za/?p=34363