Having Said that the subsequent section I am having difficulties to try and do once the mass copy and paste has run I would like Yet another code that will update column A accordingly these which the Work num from sheet two will fill in to each in between tasks http://rivonirecruitment.co.za/?p=34323