Nonetheless The next part I am having difficulties to perform once the mass copy and paste has run I want An additional code that will update column A appropriately these types of that the Occupation num from sheet two will fill in to every between duties two and 10,000 I http://new.jesusaction.org/bbs/board.php?bo_table=free&wr_id=1907297