Having Said that another element I'm having difficulties to carry out after the mass copy and paste has operate I need One more code which will update column A appropriately such the Position num from sheet 2 will fill in to every between duties 2 and ten,000 I have attached http://101.101.211.199/bbs/board.php?bo_table=free&wr_id=3127005