On The other hand the following part I'm struggling to perform after the mass copy and paste has run I want another code that can update column A accordingly this sort of which the Occupation num from sheet 2 will fill in to every between duties two and ten,000 I've http://mtthub.org/groups/the-fact-about-mass-copy-and-paste-in-excel-that-no-one-is-suggesting-1129091289/