PDA

View Full Version : Move Files from current folder to a new subfolder specified in a column



zEKeBv
12-29-2020, 01:07 PM
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 !

zEKeBv
12-31-2020, 02:11 AM
You can close the tread. Solved it myself.

snb
01-02-2021, 08:50 AM
Your solution can be improved considerably.

zEKeBv
01-03-2021, 05:06 AM
I'm not an expert ! That's why a created this thread...

Thanks snb ! When I asked for help, no one showed up ! Now you make judgements ! Thanks a lot !

I repeat, You can close the thread !

zEKeBv
01-11-2021, 12:45 PM
Ho F.u.c.K Yourself !

Maybe this time you will close the thread ! You idiot !