Having Said that the subsequent part I'm struggling to accomplish following the mass copy and paste has operate I want A different code that can update column A appropriately such the Career num from sheet 2 will fill in to each between duties two and 10,000 I have attached the https://kormarines.com/bbs/bbs/board.php?bo_table=free&wr_id=1222027