Nonetheless The next portion I'm battling to carry out once the mass copy and paste has operate I want One more code which will update column A appropriately such which the Career num from sheet 2 will fill in to every between responsibilities 2 and ten,000 I've attached the sheet https://christianz946mji5.wikilima.com/user