Even So another portion I'm struggling to carry out following the mass copy and paste has operate I need One more code which will update column A accordingly such the Career num from sheet two will fill in to every in between jobs 2 and 10,000 I have attached the http://rivonirecruitment.co.za/?p=34331