Nevertheless The following part I am struggling to do after the mass copy and paste has run I want Yet another code that could update column A accordingly these that the Career num from sheet two will fill in to each in between duties two and 10,000 I've attached the https://forum.theomegacollective.com/forums/users/camillaraine3/