Nonetheless Another element I'm struggling to carry out after the mass copy and paste has operate I want A further code that will update column A accordingly this sort of which the Occupation num from sheet 2 will fill in to each in between tasks 2 and ten,000 I have http://rivonirecruitment.co.za/?p=34325