Having Said that the next aspect I am having difficulties to do once the mass copy and paste has operate I would like One more code that can update column A accordingly these kinds of which the Occupation num from sheet two will fill in to every in between duties https://whoawho.com/bbs/board.php?bo_table=free&wr_id=6015