Nonetheless the next part I am battling to do after the mass copy and paste has run I would like An additional code that can update column A appropriately these that the Work num from sheet two will fill in to each between responsibilities 2 and ten,000 I have attached the sheet and additional a remaining Option sheet in case my clarification didn'