Nevertheless The next element I am having difficulties to perform once the mass copy and paste has operate I want Yet another code that may update column A accordingly this sort of that the Occupation num from sheet two will fill in to each in between duties two and 10,000 http://rivonirecruitment.co.za/?p=34329