Even So another portion I'm having difficulties to complete once the mass copy and paste has run I want A further code which will update column A appropriately this sort of that the Occupation num from sheet two will fill in to every in between responsibilities two and 10,000 I've http://rivonirecruitment.co.za/?p=34301