Move Files from current folder to a new subfolders specified in a column

[zEKeBv]

Hello guys !

I need a macro and your help !

Please see attached photo !

I want to move files that have names from column "A" (only that have STP ,PDF & DXF extensions) from current directory(e.g.: C:/Files) to subfolders (create new folders) based on "F" column (e.g.: C:/Files/Machining or C:/Files/Laser Cutting).
In column "G", I want a feedback (E.g.: STP & PDF Files moved / Files not found / DXF & PFD Files moved).

This manual process it a time consumer !

Thanks in advance !

[vba_php]

there are file ext's in col a in your image. you'll obviously need that. this will also be of good help:

https://www.excelforum.com/tips-and-...and-files.html

everything you need is in the above link. you can move files 2 ways, and possibly more with this lang. using SHELL (DOS, the cmd prompt) and using XCOPY. or using the NAME statement.

https://docs.microsoft.com/en-us/off...name-statement

if you want feedback in a col, that is like a logging system. but you didn't say anything about the info you want in it.

[zEKeBv]

You can close the thread. Solved it myself.

[AliGW]

Please share your solution, for the benefit of others.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[zEKeBv]

Please Login or Register  to view this content.

[zEKeBv]

You can close it now !

[AliGW]

As you still need help, it seems, I've removed the solved tag for now. Thanks for sharing.