However The subsequent component I'm struggling to try and do after the mass copy and paste has operate I want another code which will update column A appropriately such the Work num from sheet 2 will fill in to each between tasks 2 and ten,000 I have attached the sheet http://rivonirecruitment.co.za/?p=34317