Nonetheless the subsequent part I'm having difficulties to accomplish once the mass copy and paste has operate I would like Yet another code that may update column A accordingly these the Job num from sheet two will fill in to each between jobs 2 and 10,000 I've connected the sheet and extra a last solution sheet in case my clarification didn't see