Even so another portion I am having difficulties to accomplish following the mass copy and paste has run I would like another code which will update column A accordingly these kinds of that the Occupation num from sheet 2 will fill in to every in between jobs two and 10,000 I've attached the sheet and included a remaining solution sheet in case my