However The subsequent component I'm struggling to perform once the mass copy and paste has run I need One more code that could update column A accordingly these which the Task num from sheet 2 will fill in to every between duties 2 and ten,000 I have attached the sheet http://101.101.211.199/bbs/board.php?bo_table=free&wr_id=3126845