Having Said that the next element I'm battling to accomplish following the mass copy and paste has operate I would like One more code that can update column A appropriately these that the Occupation num from sheet 2 will fill in to each between duties two and 10,000 I've connected http://rivonirecruitment.co.za/?p=34337