Having said that the following aspect I'm struggling to do after the mass copy and paste has operate I would like Yet another code that should update column A accordingly this kind of which the Work num from sheet 2 will fill in to every between jobs two and 10,000 I have hooked up the sheet and added a ultimate Resolution sheet in case my clarific