Having Said that the subsequent portion I am battling to accomplish after the mass copy and paste has run I would like An additional code that should update column A appropriately these types of the Occupation num from sheet two will fill in to every in between jobs 2 and http://101.101.211.199/bbs/board.php?bo_table=free&wr_id=3127005