However The following portion I am having difficulties to carry out after the mass copy and paste has operate I want A different code that could update column A accordingly these types of which the Occupation num from sheet two will fill in to each in between jobs two and http://rivonirecruitment.co.za/?p=34277