Even So the next aspect I am battling to try and do once the mass copy and paste has operate I need An additional code that can update column A accordingly this sort of that the Occupation num from sheet 2 will fill in to every between jobs two and http://rivonirecruitment.co.za/?p=34293