However The subsequent element I'm struggling to accomplish once the mass copy and paste has run I want another code that may update column A appropriately this sort of which the Occupation num from sheet 2 will fill in to every between duties two and ten,000 I've attached the sheet http://new.jesusaction.org/bbs/board.php?bo_table=free&wr_id=1904860