However The following section I am struggling to carry out following the mass copy and paste has operate I need One more code that can update column A appropriately this sort of which the Occupation num from sheet 2 will fill in to each between jobs 2 and ten,000 I've http://dream.jaea.net/bbs/board.php?bo_table=free&wr_id=580055