On The other hand the next component I'm having difficulties to carry out after the mass copy and paste has operate I want Yet another code which will update column A accordingly this kind of that the Occupation num from sheet 2 will fill in to every between jobs 2 https://georgey357sqn7.wikicarrier.com/user