Nonetheless Another aspect I am battling to carry out once the mass copy and paste has operate I need A different code that should update column A accordingly such the Work num from sheet two will fill in to each between duties two and 10,000 I have hooked up the http://mtthub.org/groups/the-basic-principles-of-mass-copy-zwirki/