However The next portion I am having difficulties to accomplish once the mass copy and paste has operate I want A different code that could update column A appropriately such which the Task num from sheet 2 will fill in to each between responsibilities 2 and 10,000 I have attached https://kormarines.com/bbs/bbs/board.php?bo_table=free&wr_id=1221941