On The other hand the next component I am struggling to accomplish after the mass copy and paste has run I would like another code that should update column A accordingly this sort of which the Job num from sheet 2 will fill in to each in between tasks 2 https://masscopyinexcel63962.wannawiki.com/1185169/mass_copy_spells_mtg_options