However another component I'm battling to try and do following the mass copy and paste has operate I want A further code that should update column A accordingly these which the Occupation num from sheet two will fill in to each between duties 2 and 10,000 I have attached the sheet and extra a ultimate Resolution sheet in case my explanation failed