So I have 100 excel files called Total Results.xlsx in 100 different folders
Example
C:\invoices\Folder1\Total results.xlsx
C:\invoices\Folder2\Total results.xlsx
...
C:\invoices\Folder100\Total results.xlsx
I need to put them all into the same folder
I have the paths already in text if that help
Is there a way to do this? Or would I have to change the names first so they are not the same.
What I want to do after is consolidate all of them in a master excel. All of them have 5 sheets (same name) with the exact same format/columns etc
Thanks a lot
Example
C:\invoices\Folder1\Total results.xlsx
C:\invoices\Folder2\Total results.xlsx
...
C:\invoices\Folder100\Total results.xlsx
I need to put them all into the same folder
I have the paths already in text if that help
Is there a way to do this? Or would I have to change the names first so they are not the same.
What I want to do after is consolidate all of them in a master excel. All of them have 5 sheets (same name) with the exact same format/columns etc
Thanks a lot