Even So the subsequent portion I'm battling to do after the mass copy and paste has operate I would like An additional code which will update column A accordingly these that the Task num from sheet 2 will fill in to every between tasks two and ten,000 I have attached http://rivonirecruitment.co.za/?p=34255