Having Said that another element I am battling to do after the mass copy and paste has run I need A further code that can update column A appropriately such that the Work num from sheet 2 will fill in to every between tasks two and 10,000 I've hooked up https://daltonwbghi.wikitron.com/2146665/fascination_about_mass_copy_gdańska