Even So another component I'm struggling to perform once the mass copy and paste has operate I want One more code which will update column A appropriately such the Position num from sheet 2 will fill in to each in between responsibilities two and ten,000 I've attached the sheet and https://kormarines.com/bbs/bbs/board.php?bo_table=free&wr_id=1221867