However The next section I am battling to carry out following the mass copy and paste has operate I need A further code that can update column A appropriately this kind of which the Job num from sheet 2 will fill in to each in between duties 2 and 10,000 http://mtthub.org/groups/helping-the-others-realize-the-advantages-of-mass-copy-in-excel/