However The following part I'm struggling to accomplish after the mass copy and paste has operate I want A further code which will update column A accordingly this kind of that the Occupation num from sheet 2 will fill in to every in between tasks two and 10,000 I've attached https://beauglsoc.wikissl.com/2076894/how_copy_messages_can_save_you_time_stress_and_money