Hello everyone, I am trying move files based upon a the names in the spreadsheet. The files in the folder also has the same name. What I want to do is to move the files to specific folders for example:
Column N1:Filename, N2:Outro.mp3, N3:Intro.mp3, N4:piano.mp3, etc
The folder where the Files are have the same names: Outro.mp3, N3:Intro.mp3, N4:piano.mp3, etc
In Column A in the same spreadsheet they are two albums Instrumental and Vocals.
Lastly in the root folders of Instrumental and Vocals are folders of combined values of 3 columns for example 1 - HGH - Tonic(Script), 2 - LOW - Legat(Pause), etc. How can the code below be modified to search for the songs in the folder as well as the excel document and separate them by albums and into the subfolders 1 - HGH - Tonic(Script), 2 - LOW - Legat(Pause) which are also folders from combined values in the same spreadsheet? Thanks
root, dirs, files,
'C:\\Users\\mrdrj\\Desktop\\NASB - Copy\\'
# Location of Songs
# List of Songs in Folder
#List of Corrected Songs in Excel
I have included the link https://github.com/giddyhead/MoveFilesExcel.git for reference. Thanks for you time.