Even So the next portion I am battling to accomplish once the mass copy and paste has operate I would like another code which will update column A accordingly this kind of which the Occupation num from sheet two will fill in to each between tasks 2 and ten,000 I http://110.10.168.238/bbs/board.php?bo_table=free&wr_id=19354