On The other hand the next element I'm battling to accomplish following the mass copy and paste has run I want An additional code that should update column A appropriately such the Job num from sheet 2 will fill in to every in between jobs two and ten,000 I've connected http://mtthub.org/groups/top-guidelines-of-copy-massage/