Nevertheless Another component I am struggling to carry out after the mass copy and paste has run I want another code that will update column A appropriately such which the Career num from sheet 2 will fill in to every between tasks two and 10,000 I've hooked up the sheet http://121.181.234.77/bbs/board.php?bo_table=blessed_pray&wr_id=1010297