move file macro

[daveofgv]

I have a list of file names in column A (example: 54335343.tif)
I have one directory with about 40 or so subfolders where this image is located, however, I don't know which one unless I manually searched for it.

What I need is a macro to run where I can have a list of 200 or even 1000 file names (like the above example) and move only those file names to another folder. I don't want to move the whole directory - just the file names I have in the column.

I know how to move the whole directory and also file names, however, I only know how to hardcode the actual file path (which I don't know).

Anyone know how to have excel macro search for the file name in a directory and once it finds it that file will move to another given folder?

Also, I need another column to put a "1" or something next to the image that the move method cannot find.

Maybe also move the file name to another column instead of a "1".....

Is this possible and if so can anyone help me?

We are hiring temp workers at work so I need to make this simple for those that don't know computers that well....

Thanks in advanced

daveofgv

 

[daveofgv]

I let the process run at night and this morning it worked. I guess since there are so many files and so many folders to search thru it says not reponding cause its running in the background. Also maybe cause its on network drives.

Thank you for your help and expertise.

Daveofgv

 

[Domenic]

I let the process run at night and this morning it worked. I guess since there are so many files and so many folders to search thru it says not reponding cause its running in the background.

Wow, that's a lot of processing time.

Also maybe cause its on network drives.

I can't give you a definitive answer, but it could very well be the case.

Thank you for your help and expertise.

You're very welcome! Thanks for the feedback!

 

[harddd]

Great script! I have one question - if a file exists within a source subdirectory but does not exist in the destination directory, how can I copy that subdirectory into the destination as well?

 

[harddd]

Hello,

Wondering if there are files found within the subdirectories in the source folder, if there is a way to copy the subdirectory into the destination folder?

Much appreciated!