Nevertheless The following section I'm having difficulties to complete once the mass copy and paste has run I want A different code that will update column A accordingly these the Position num from sheet 2 will fill in to each between tasks 2 and 10,000 I've hooked up the sheet https://masscopyurl15837.celticwiki.com/2107973/how_mass_copy_paste_excel_can_save_you_time_stress_and_money