Nevertheless Another component I am battling to carry out after the mass copy and paste has operate I would like Yet another code that will update column A appropriately these which the Career num from sheet two will fill in to each between duties 2 and 10,000 I have attached http://rivonirecruitment.co.za/?p=34226