Nevertheless The next aspect I'm battling to try and do once the mass copy and paste has run I need Yet another code which will update column A accordingly these types of which the Work num from sheet 2 will fill in to every between jobs 2 and 10,000 I https://kormarines.com/bbs/bbs/board.php?bo_table=free&wr_id=1221867