Nonetheless The subsequent aspect I'm battling to perform once the mass copy and paste has operate I want another code that will update column A accordingly these which the Career num from sheet two will fill in to each between responsibilities 2 and ten,000 I've attached the sheet and included waiting for link from Social Network Posts (2)