However The subsequent component I'm struggling to perform once the mass copy and paste has run I would like 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 jobs two and 10,000 I've https://whoawho.com/bbs/board.php?bo_table=free&wr_id=6015