Nonetheless The following part I'm struggling to do following the mass copy and paste has operate I need One more code that should update column A accordingly these that the Task num from sheet 2 will fill in to each between responsibilities 2 and 10,000 I've attached the sheet and https://thevictory.co.kr/bbs/board.php?bo_table=free&wr_id=97708