However Another portion I am battling to accomplish once the mass copy and paste has run I want A further code that may update column A appropriately these types of the Career num from sheet two will fill in to each between responsibilities two and ten,000 I've connected the sheet http://101.101.211.199/bbs/board.php?bo_table=free&wr_id=3126704