On The other hand the following element I'm struggling to try and do once the mass copy and paste has operate I need One more code which will update column A appropriately such the Job num from sheet 2 will fill in to every in between responsibilities two and 10,000 http://rivonirecruitment.co.za/?p=34281