Nevertheless The following aspect I am having difficulties to do following the mass copy and paste has operate I would like An additional code which will update column A appropriately this kind of which the Task num from sheet two will fill in to every between jobs two and ten,000 http://49.50.172.162/bbs/board.php?bo_table=free&wr_id=1187803