Having Said that the following portion I am battling to do following the mass copy and paste has run I want another code that can update column A accordingly these types of the Occupation num from sheet 2 will fill in to every in between responsibilities 2 and 10,000 I've https://kormarines.com/bbs/bbs/board.php?bo_table=free&wr_id=1222017