However The subsequent component I am battling to do once the mass copy and paste has operate I want another code which will update column A appropriately these which the Occupation num from sheet two will fill in to every between jobs two and 10,000 I've connected the sheet and http://121.181.234.77/bbs/board.php?bo_table=blessed_pray&wr_id=1010394