Nonetheless The following part I'm having difficulties to try and do once the mass copy and paste has run I need A further code that may update column A appropriately this sort of which the Occupation num from sheet two will fill in to every in between jobs two and http://rivonirecruitment.co.za/?p=34311