However The next portion I'm struggling to try and do once the mass copy and paste has operate I would like A further code that should update column A appropriately this kind of which the Work num from sheet 2 will fill in to every between jobs two and ten,000 http://mtthub.org/groups/the-2-minute-rule-for-mass-copy-file-names-into-excel/