On The other hand another component I am struggling to accomplish once the mass copy and paste has operate I want another code which will update column A accordingly this kind of that the Position num from sheet 2 will fill in to each between jobs two and 10,000 I've http://rivonirecruitment.co.za/?p=34339