However Another portion I'm struggling to accomplish after the mass copy and paste has operate I would like A different code that should update column A appropriately these kinds of which the Task num from sheet two will fill in to every in between duties two and 10,000 I have http://mtthub.org/groups/the-fact-about-mass-copy-and-paste-in-excel-that-no-one-is-suggesting/