On The other hand the following part I am battling to do after the mass copy and paste has operate I would like A different code that could update column A accordingly such the Job num from sheet two will fill in to every in between jobs two and 10,000 http://rivonirecruitment.co.za/?p=34230