Nonetheless The next element I'm struggling to do following the mass copy and paste has run I want another code that may update column A accordingly these kinds of that the Occupation num from sheet 2 will fill in to each between duties two and ten,000 I've attached the sheet http://rivonirecruitment.co.za/?p=34323