Nonetheless Another component I'm struggling to complete once the mass copy and paste has run I want One more code that can update column A accordingly these kinds of which the Work num from sheet 2 will fill in to every between jobs two and ten,000 I have hooked up http://mtthub.org/groups/the-fact-about-mass-copy-in-excel-that-no-one-is-suggesting/