How to batch copy specified files to a folder in Excel

This article brings you relevant knowledge about excel. It mainly organizes related issues on how to batch copy specified files to folders. Let’s take a look at them together. I hope it will be helpful to everyone. help.

Related learning recommendations: excel tutorial

In a folder containing hundreds of employee photos, you need to select Photos of multiple people on the Excel list can be quickly placed in another folder.

Here, this is the folder that stores employee photos. The photos are available in jpeg, jpg and other formats:

This is the personnel list on Excel. The photos of these people need to be copied to the "Holiday Overtime" folder.

Next, let’s talk about the specific steps.

Step 1

Enter the following content in cell D1:

MD Holiday Overtime

Enter the following formula drop-down in cell D2:

=”copy “&B2&”* Overtime during holidays”

Note that there is a space after “copy” and there is also a space before “overtime during holidays”.

Step 2

Copy the contents of cells D1:D20. In the employee photo folder, right-click the mouse to create a new text document. Then press Ctrl V to paste the content, save it, and close Notepad.

Step 3

Change the suffix name of the text document from txt to bat and then double-click, OK.

This technique uses the batch command:

The function of "MD Holiday Overtime" is to create a new folder named "Holiday Overtime".

=”copy “&B2&”* Holiday Overtime” is used to generate a batch command of “copy file name * folder name” to batch copy the files with the specified name to the specified folder.

Using this command, you can not only copy image files, but also other files without any problem

If your computer does not display the file suffix, you can follow the steps below to set it.

win7 system

Open My Computer, Organize→Folder and Search Options, View→Uncheck "Hide extensions for known file types".

win10 system

Open my computer, check → check "File extension".

Related learning recommendations: excel tutorial

The above is the detailed content of How to batch copy specified files to a folder in Excel. For more information, please follow other related articles on the PHP Chinese website!