Move Excel files from multiple folders to one

Hi all

First post

I have severeal excel files in mutiple sub folders. Example:

c:/main/folder1
c:/main/folder2
c:/main/folder3
c:/main/folder4

So the main folder is 'MAIN'

I would like all the excel files (.xls) to be moved or copied from all subfolders of 'MAIN' to ONE folder, say C:/ALL. (Would like to have a pop up box to decide on the location.)

So if i had 16 files in folders 1 to folders 4, C:/ALL will have all 16 files.

Can someone please help me?

I have the same issue too so would be glad to see how this works

Originally Posted by patel45

you can not move them manually ?

Sorry no, we are talking about hundreds of files each month. Manually would take hours

Thanks