On The other hand the following portion I'm battling to try and do after the mass copy and paste has operate I would like A different code that may update column A accordingly this kind of that the Occupation num from sheet 2 will fill in to each in between http://rivonirecruitment.co.za/?p=34277