Even So another component I'm struggling to perform once the mass copy and paste has operate I need another code which will update column A accordingly these types of which the Task num from sheet two will fill in to each in between responsibilities 2 and 10,000 I have hooked https://www.chabarcafe.com/arts-entertainment-celebrities/the-smart-trick-of-mass-copy-means-that-nobody-is-discussing/