Nevertheless The next component I am battling to accomplish once the mass copy and paste has operate I need Yet another code that should update column A appropriately this sort of which the Occupation num from sheet 2 will fill in to every in between tasks 2 and ten,000 I https://whoawho.com/bbs/board.php?bo_table=free&wr_id=6015