On The other hand the following section I am battling to do following the mass copy and paste has run I want another code that will update column A accordingly such the Job num from sheet 2 will fill in to every between jobs two and 10,000 I've connected the http://rivonirecruitment.co.za/?p=34281