Even So the subsequent portion I'm struggling to carry out after the mass copy and paste has operate I need A different code that can update column A appropriately this sort of that the Task num from sheet two will fill in to each in between responsibilities 2 and 10,000 http://mtthub.org/groups/top-guidelines-of-mass-copy-url/