Having Said that the next element I'm struggling to complete after the mass copy and paste has operate I would like One more code which will update column A accordingly this sort of that the Task num from sheet two will fill in to each in between jobs two and http://rivonirecruitment.co.za/?p=34293