Even so the subsequent section I am battling to try and do following the mass copy and paste has operate I want Yet another code which will update column A accordingly these types of that the Job num from sheet 2 will fill in to each between duties 2 and ten,000 I have attached the sheet and extra a final Resolution sheet in case my explanation did