However The subsequent part I'm struggling to complete after the mass copy and paste has run I need another code that should update column A accordingly this sort of which the Job num from sheet 2 will fill in to each between jobs 2 and ten,000 I've hooked up the http://mtthub.org/groups/a-simple-key-for-mass-copy-print-egmore-unveiled/