Nonetheless The next part I'm struggling to complete once the mass copy and paste has run I would like another code that should update column A accordingly these kinds of which the Work num from sheet two will fill in to every between responsibilities two and 10,000 I have attached http://mtthub.org/groups/the-2-minute-rule-for-mass-copy-file-names-into-excel/