Nonetheless The next portion I am battling to accomplish once the mass copy and paste has operate I need Yet another code that can update column A accordingly these that the Occupation num from sheet 2 will fill in to every in between responsibilities two and ten,000 I have hooked https://mass-copy-sheets-in-excel91345.blogrenanda.com/46499964/getting-my-copy-message-link-to-work