Having Said that another section I'm struggling to do once the mass copy and paste has run I need A further code that will update column A appropriately this kind of which the Work num from sheet two will fill in to each between tasks 2 and 10,000 I have http://49.50.172.162/bbs/board.php?bo_table=free&wr_id=1188021