Even So the following section I am battling to complete after the mass copy and paste has operate I want another code that could update column A accordingly these kinds of which the Occupation num from sheet two will fill in to every between responsibilities 2 and ten,000 I've hooked http://mtthub.org/groups/top-guidelines-of-mass-copy-url-515071606/