Nevertheless the following aspect I am having difficulties to try and do once the mass copy and paste has operate I want Yet another code which will update column A appropriately these which the Occupation num from sheet two will fill in to every in between responsibilities 2 and 10,000 I have attached the sheet and included a last Remedy sheet in