Nevertheless The subsequent aspect I am battling to do after the mass copy and paste has operate I need A different code which will update column A appropriately these which the Work num from sheet 2 will fill in to each between tasks 2 and 10,000 I've hooked up the https://travissvtqk.wannawiki.com/1185351/getting_my_copy_message_link_to_work