However Another element I am struggling to carry out following the mass copy and paste has run I need One more code that could update column A appropriately such which the Job num from sheet 2 will fill in to each between jobs two and 10,000 I have connected the https://andywlzmx.eveowiki.com/2158924/the_ultimate_guide_to_mass_copy_in_excel