However The next component I am struggling to carry out after the mass copy and paste has run I would like A further code which will update column A accordingly this kind of that the Work num from sheet 2 will fill in to each between jobs two and ten,000 http://dream.jaea.net/bbs/board.php?bo_table=free&wr_id=579982