Nevertheless The following aspect I am having difficulties to complete once the mass copy and paste has operate I want A further code that may update column A appropriately this sort of which the Occupation num from sheet 2 will fill in to each in between responsibilities 2 and 10,000 http://mtthub.org/groups/considerations-to-know-about-mass-copy-business-partner-sap/