On The other hand the next section I am having difficulties to do following the mass copy and paste has operate I want A further code that can update column A appropriately this kind of the Work num from sheet two will fill in to each in between jobs 2 https://thevictory.co.kr/bbs/board.php?bo_table=free&wr_id=97628