Having Said that the following portion I am having difficulties to complete following the mass copy and paste has operate I need A different code which will update column A accordingly these kinds of that the Work num from sheet two will fill in to every in between duties two http://rivonirecruitment.co.za/?p=34273