Nonetheless Another portion I am battling to perform following the mass copy and paste has operate I need One more code that will update column A accordingly such which the Position num from sheet 2 will fill in to each between responsibilities 2 and 10,000 I have attached the sheet http://mtthub.org/groups/the-2-minute-rule-for-mass-copy-roles-sap-717331768/