Nevertheless The next section I'm battling to try and do following the mass copy and paste has operate I want An additional code that will update column A accordingly these types of which the Task num from sheet 2 will fill in to each in between jobs 2 and 10,000 Successfully Submitted (Awaiting Approval)