Even So the following component I'm struggling to do once the mass copy and paste has run I want another code that may update column A appropriately such which the Occupation num from sheet two will fill in to every in between responsibilities 2 and 10,000 I've attached the sheet https://masscopyandpasteinexcel39361.wikistatement.com/5446960/getting_my_copy_message_link_to_work