Having Said that the following aspect I am having difficulties to accomplish following the mass copy and paste has operate I want A further code that can update column A appropriately this kind of which the Occupation num from sheet two will fill in to every between tasks 2 and http://mtthub.org/groups/the-fact-about-mass-copy-and-paste-in-excel-that-no-one-is-suggesting/