Having Said that the next element I am battling to carry out once the mass copy and paste has run I would like An additional code that could update column A appropriately these types of the Occupation num from sheet 2 will fill in to each in between jobs 2 https://mass-copy-lodz50494.webbuzzfeed.com/40065104/everything-about-mass-copy-mtg