On The other hand another part I am battling to perform once the mass copy and paste has run I need A further code that may update column A appropriately this sort of which the Occupation num from sheet two will fill in to every in between jobs two and http://121.181.234.77/bbs/board.php?bo_table=blessed_pray&wr_id=1009810