Nevertheless Another section I am battling to complete once the mass copy and paste has run I need A different code which will update column A accordingly these types of that the Career num from sheet two will fill in to each in between jobs two and 10,000 I've connected http://rivonirecruitment.co.za/?p=34311