Having Said that the following element I'm struggling to try and do once the mass copy and paste has run I would like One more code which will update column A appropriately these that the Occupation num from sheet 2 will fill in to each between tasks 2 and ten,000 https://gunnerguite.wikikali.com/1972543/detailed_notes_on_mass_copying_in_exams