On The other hand the next component I'm battling to complete following the mass copy and paste has operate I need One more code that will update column A accordingly these types of the Work num from sheet two will fill in to each in between jobs two and 10,000 http://mtthub.org/groups/the-best-side-of-mass-copy-zwirki/