However The following part I'm struggling to perform once the mass copy and paste has run I want A further code that may update column A appropriately this kind of that the Occupation num from sheet 2 will fill in to every in between duties two and ten,000 I've attached http://mtthub.org/groups/not-known-details-about-mass-copy-ka-matlab/