Having Said that another portion I am having difficulties to accomplish once the mass copy and paste has run I want another code that could update column A accordingly these kinds of which the Work num from sheet two will fill in to every in between jobs two and 10,000 http://mtthub.org/groups/top-guidelines-of-mass-copy-url/