Even So another portion I'm having difficulties to perform after the mass copy and paste has run I want One more code that can update column A accordingly these which the Work num from sheet two will fill in to every in between jobs two and 10,000 I have connected http://mtthub.org/groups/top-mass-copy-paste-excel-secrets/