Even So the subsequent aspect I'm struggling to carry out after the mass copy and paste has run I want A different code that may update column A accordingly such that the Occupation num from sheet two will fill in to each in between tasks 2 and 10,000 I've connected https://masscopyandpasteinexcel06937.blogaritma.com/37678884/what-does-mass-copy-roles-sap-mean