Having Said that the following component I'm struggling to perform after the mass copy and paste has operate I would like another code that should update column A accordingly such the Task num from sheet two will fill in to each between duties two and 10,000 I have attached the http://rivonirecruitment.co.za/?p=34228