Even So the next part I'm battling to carry out after the mass copy and paste has run I would like Yet another code that can update column A accordingly these which the Task num from sheet 2 will fill in to each between duties two and 10,000 I have Successfully Submitted (Awaiting Approval)