I am trying to copy a list of files and folders based on the source column in a Excel to a new location. I have an excel list of the files and folders that need to be copied and keep partial original path (See screenshot) desire outcome.
Is there anyway at all I can use a code or anything to automatically move those files and folders.
Thank you
Is there anyway at all I can use a code or anything to automatically move those files and folders.
Source | Destination | Desired Outcome | Comments |
---|---|---|---|
N:\20 - Electronic Files\1- MyAA Files\2013 fall\fileme.pdf | N:\20 - Electronic Files\ | N:\20 - Electronic Files\2013 fall\fileme.pdf | copy this file and create the 1 level up folder |
N:\20 - Electronic Files\1- MyAA Files\ET Folder\2014 fall\ | N:\20 - Electronic Files\ | N:\20 - Electronic Files\2014 fall\*.* | copy this folder and all files under |
N:\20 - Electronic Files\1- MyAA Files\ET Folders\2024 summer\101file.pdf | N:\20 - Electronic Files\ | N:\20 - Electronic Files\2024 summer\101file.pdf | copy this file and create the 1 level up folder |
N:\20 - Electronic Files\1- MyAA Files\ET Folders\2025 winter\ | N:\20 - Electronic Files\ | N:\20 - Electronic Files\2025 winter\*.* | copy this folder and all files under |
Thank you