Nevertheless The next aspect I am struggling to try and do after the mass copy and paste has operate I want Yet another code that will update column A accordingly this kind of which the Career num from sheet two will fill in to every between responsibilities 2 and ten,000 Successfully Submitted (Awaiting Approval)