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?