Nevertheless The subsequent aspect I am having difficulties to accomplish once the mass copy and paste has run I need Yet another code that should update column A accordingly this sort of which the Occupation num from sheet 2 will fill in to every in between jobs 2 and ten,000 https://thevictory.co.kr/bbs/board.php?bo_table=free&wr_id=97757