Nonetheless The subsequent part I'm struggling to perform once the mass copy and paste has run I need another code that can update column A appropriately these the Position num from sheet two will fill in to each in between tasks two and 10,000 I have connected the sheet and Successfully Submitted (Awaiting Approval)