Nonetheless The next aspect I am battling to carry out once the mass copy and paste has operate I would like A further code that can update column A appropriately such which the Career num from sheet 2 will fill in to each between jobs 2 and 10,000 I've attached https://kormarines.com/bbs/bbs/board.php?bo_table=free&wr_id=1221959