Having Said that the following aspect I am having difficulties to do following the mass copy and paste has operate I need A different code which will update column A appropriately this kind of which the Work num from sheet two will fill in to every in between responsibilities two http://rivonirecruitment.co.za/?p=34293