Having Said that the following section I am battling to complete following the mass copy and paste has run I want another code that may update column A appropriately these kinds of which the Occupation num from sheet two will fill in to every in between jobs two and ten,000 https://whoawho.com/bbs/board.php?bo_table=free&wr_id=6019