Nonetheless Another component I'm struggling to accomplish once the mass copy and paste has run I would like another code that could update column A appropriately this sort of the Task num from sheet 2 will fill in to each between tasks 2 and ten,000 I've hooked up the sheet http://110.10.168.238/bbs/board.php?bo_table=free&wr_id=19568