Nevertheless The next portion I am battling to perform after the mass copy and paste has operate I would like another code that should update column A accordingly these types of the Career num from sheet 2 will fill in to each between jobs two and ten,000 I've hooked up http://101.101.211.199/bbs/board.php?bo_table=free&wr_id=3126780