On The other hand the following section I am struggling to try and do after the mass copy and paste has operate I need Yet another code that will update column A accordingly this sort of which the Occupation num from sheet two will fill in to every in between https://thevictory.co.kr/bbs/board.php?bo_table=free&wr_id=97708