Even So another element I'm struggling to carry out after the mass copy and paste has run I would like another code that will update column A accordingly these that the Task num from sheet two will fill in to each in between responsibilities 2 and 10,000 I have attached http://mtthub.org/groups/the-smart-trick-of-mass-copy-means-that-nobody-is-discussing/