Even So the next aspect I'm battling to carry out following the mass copy and paste has operate I want A different code that can update column A appropriately these which the Occupation num from sheet two will fill in to each in between jobs two and 10,000 I have http://mtthub.org/groups/a-simple-key-for-mass-copy-print-egmore-unveiled/