Nevertheless The subsequent component I'm struggling to carry out after the mass copy and paste has operate I want One more code that can update column A accordingly these that the Task num from sheet two will fill in to each in between responsibilities 2 and 10,000 I have attached http://rivonirecruitment.co.za/?p=34341