On The other hand another portion I am having difficulties to complete after the mass copy and paste has run I would like A further code that will update column A appropriately this sort of which the Work num from sheet 2 will fill in to every in between jobs http://101.101.211.199/bbs/board.php?bo_table=free&wr_id=3126660