However The subsequent component I'm having difficulties to complete following the mass copy and paste has operate I would like A different code which will update column A appropriately such the Career num from sheet two will fill in to every in between jobs two and 10,000 I've hooked up http://110.10.168.238/bbs/board.php?bo_table=free&wr_id=19354