Nonetheless Another part I'm struggling to try and do following the mass copy and paste has operate I would like One more code which will update column A accordingly this sort of that the Work num from sheet two will fill in to every in between jobs two and ten,000 http://the-good.kr/bbs/board.php?bo_table=free&wr_id=4591232