On The other hand the next portion I am having difficulties to complete following the mass copy and paste has run I need A further code that may update column A accordingly such that the Position num from sheet two will fill in to every between jobs 2 and 10,000 http://mtthub.org/groups/the-2-minute-rule-for-mass-copy-file-names-into-excel/