Nonetheless Another part I am having difficulties to do once the mass copy and paste has run I want A different code that can update column A appropriately this sort of the Job num from sheet 2 will fill in to each in between duties 2 and 10,000 I've hooked http://dream.jaea.net/bbs/board.php?bo_table=free&wr_id=580090