Nevertheless the following section I am battling to accomplish following the mass copy and paste has run I need another code that may update column A accordingly this sort of the Job num from sheet 2 will fill in to every between duties two and ten,000 I've hooked up the sheet and additional a final Resolution sheet in case my explanation failed to