Having Said that the subsequent section I am battling to accomplish once the mass copy and paste has run I need A further code that can update column A appropriately such the Job num from sheet 2 will fill in to every between duties two and ten,000 I've hooked up http://49.50.172.162/bbs/board.php?bo_table=free&wr_id=1187816