On The other hand another portion I am having difficulties to accomplish once the mass copy and paste has run I want A further code that can update column A appropriately this kind of the Occupation num from sheet 2 will fill in to every in between jobs 2 and https://www.chabarcafe.com/internet-business-web-design/mass-copy-zwirki-fundamentals-explained/