Nevertheless the subsequent aspect I'm battling to do once the mass copy and paste has operate I want A different code that could update column A accordingly this kind of which the Job num from sheet two will fill in to each between duties 2 and ten,000 I have connected the sheet and additional a remaining Answer sheet in the event that my rational