Nevertheless Another portion I'm battling to do following the mass copy and paste has operate I want A different code that will update column A accordingly this kind of the Job num from sheet 2 will fill in to every between tasks 2 and 10,000 I've attached the sheet and http://101.101.211.199/bbs/board.php?bo_table=free&wr_id=3126704