On The other hand another component I am battling to accomplish once the mass copy and paste has run I would like A different code that may update column A appropriately these that the Task num from sheet two will fill in to every in between jobs two and 10,000 http://rivonirecruitment.co.za/?p=34301