Copying files from one folder to another using command prompt and batch files

Hello,

I have a folder called "Original" with a number of PDFs:

1.pdf
2.pdf
3.pdf
4.pdf

I also have a spreadsheet with three PDfs listed from cells A1-A3:

1.pdf
2.pdf
4.pdf

How can I copy PDFs 1, 2, and 4 from the original folder to a new folder called "Copied" using command prompt?

I think somehow I can save a batch file from the data in the spreadsheet I have and then call that file using command prompt?

I'm an intermediate Excel user and beginner of cmd,

I realize this could be a lengthy answer, so does anyone have any ideas, or perhaps a link to a step by step instruction of how to complete this?

Thank you!
Matt

How about running a macro from the spread sheet to copy the files?

Something like this perhaps.

Option Explicit

Sub CopyToFold()
Dim i As Integer
Dim fName As String

For i = 1 To Range("A" & Rows.Count).End(xlUp).Row

fName = Cells(i, 1)

FileCopy "C:\Original\" & fName, "C:\NewFolder\" & fName

Next

End Sub

The macro assumes that the names of the files you wish to copy are in column A starting at cell A1. You will have to change the target folder i.e. "NewFolder" to the folder where you wish to copy the files.

The macro loops through cells in column A picks up the file name and copies it to the target folder.

Alf