Nonetheless The following part I'm battling to perform once the mass copy and paste has run I want An additional code which will update column A appropriately such the Career num from sheet 2 will fill in to every in between jobs 2 and 10,000 I've connected the sheet and http://mtthub.org/groups/the-fact-about-mass-copy-in-excel-that-no-one-is-suggesting/