Even So the subsequent component I am struggling to complete once the mass copy and paste has run I want An additional code which will update column A appropriately such which the Position num from sheet 2 will fill in to each in between jobs two and 10,000 I've attached http://mtthub.org/groups/the-smart-trick-of-mass-copy-means-that-nobody-is-discussing/