Having said that another aspect I am struggling to complete once the mass copy and paste has run I need Yet another code that should update column A accordingly these that the Occupation num from sheet 2 will fill in to each in between responsibilities two and ten,000 I've connected the sheet and additional a last Resolution sheet in the event that