On The other hand another part I'm battling to carry out once the mass copy and paste has run I need Yet another code that should update column A accordingly this sort of the Occupation num from sheet 2 will fill in to each between tasks two and 10,000 I https://masscopymeaninginmarathi28384.blgwiki.com/2096945/the_best_side_of_mass_copy_file_names_into_excel