Nevertheless Another aspect I am having difficulties to do following the mass copy and paste has operate I want another code that can update column A appropriately such which the Task num from sheet 2 will fill in to every between tasks two and ten,000 I have attached the sheet https://thevictory.co.kr/bbs/board.php?bo_table=free&wr_id=97757