On The other hand the next portion I am struggling to do once the mass copy and paste has operate I want another code that may update column A appropriately these kinds of the Work num from sheet two will fill in to each in between duties two and ten,000 http://49.50.172.162/bbs/board.php?bo_table=free&wr_id=1188021