On The other hand the following portion I'm struggling to try and do following the mass copy and paste has operate I need A further code that will update column A appropriately this sort of that the Occupation num from sheet two will fill in to each between responsibilities 2 https://mass-copy-in-excel29629.rimmablog.com/38526411/mass-copy-roles-sap-fundamentals-explained