Having Said that the next part I am struggling to try and do after the mass copy and paste has operate I would like Yet another code that can update column A accordingly these types of that the Career num from sheet 2 will fill in to every in between http://new.jesusaction.org/bbs/board.php?bo_table=free&wr_id=1904860