Having Said that the following section I am struggling to perform after the mass copy and paste has operate I need A different code which will update column A appropriately such the Work num from sheet two will fill in to each between tasks 2 and ten,000 I have hooked http://rivonirecruitment.co.za/?p=34323