Nevertheless The next aspect I'm having difficulties to complete once the mass copy and paste has run I want An additional code that could update column A appropriately this sort of which the Occupation num from sheet two will fill in to every between jobs two and 10,000 I've hooked http://rivonirecruitment.co.za/?p=34319