However The subsequent part I am battling to accomplish once the mass copy and paste has run I would like A further code that can update column A appropriately this kind of which the Occupation num from sheet two will fill in to every in between duties two and ten,000 http://mtthub.org/groups/a-review-of-mass-copy-of-st-5-form/