Even So the following aspect I am battling to perform once the mass copy and paste has run I want An additional 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 two and 10,000 http://mtthub.org/groups/the-best-side-of-mass-copy-zwirki-363147602/