Nevertheless Another element I'm struggling to try and do after the mass copy and paste has run I need An additional code that can update column A accordingly these types of the Work num from sheet 2 will fill in to each between tasks 2 and ten,000 I have attached http://rivonirecruitment.co.za/?p=34305