Nonetheless Another component I'm battling to complete once the mass copy and paste has operate I want One more code that may update column A appropriately these which the Occupation num from sheet 2 will fill in to each between duties 2 and 10,000 I've connected the sheet and additional https://landennmlgc.buyoutblog.com/39731272/the-smart-trick-of-mass-copy-that-no-one-is-discussing