Having Said that the subsequent portion I'm battling to perform once the mass copy and paste has run I need One more code which will update column A appropriately such the Work num from sheet 2 will fill in to each between duties two and 10,000 I've hooked up the https://cruzrwajw.life-wiki.com/2127085/new_step_by_step_map_for_mass_copy_of_st_5_form