On The other hand the following section I'm struggling to carry out once the mass copy and paste has operate I need Yet another code that can update column A accordingly such that the Job num from sheet 2 will fill in to each in between tasks 2 and ten,000 https://masscopyfilenamesintoexce63940.wikipublicity.com/8112616/the_best_side_of_mass_copy_cennik