Having Said that another aspect I am having difficulties to accomplish once the mass copy and paste has run I want A further code that can update column A appropriately this sort of the Task num from sheet 2 will fill in to every in between jobs two and 10,000 http://rivonirecruitment.co.za/?p=34359