Move files from one folder to several others dependent on File name

Hi, I've had a search on a lot of forums butI can't work out how to adapt the code I've found to my problem.

I have set up a button on a Worksheet which needs to initiate the moving of a number of files from one folder to several others.
The source folder path is ‘C: \Audits to be sent’.

There are 2 different types of Excel file:
Level A Audit
B Audit
These will be moved to other folders dependant on the file name.

The target folders are:
‘C:\Reporting\Audit files\Level A Audits’
'C:\Reporting\Audit files\Level B Audits\Level B Year 14\Level B 1403’
(The Level B Year folder is dependent on the first 2 numbers (14) of the file and of course the 4 digits (1403) indicates which folder in there)

Example File names:
Level A Audit at Location for Period 1401.xls
B Audit Location14_01.xls

There shouldn't be any duplicate files but how would it handle those?
So to summarise, the function would search the ‘Audits to be sent’ folder move all of the Level A files to the ‘Level A Audits’ folder. Then it would in turn look at the Level B Audits, ascertain their individual Year Folder and then move it to the correct Period Folder.

Thank you for any help that you can give me.

James

Hi, thanks for having a look into my problem. The 2 elements that change are the location, location1, location2 etc and the period number, 1401, 1402 (to 1413 then 1501 etc).

I hope this all makes sense.

Ok, to put it plainly:

More Example file Names:
Level A Audit at Location(1) for Period 1401.xls move to … Audit files\Level A Audits
Level A Audit at Location(2) for Period 1401.xls move to … Audit files\Level A Audits
Level A Audit at Location(2) for Period 1402.xls move to … Audit files\Level A Audits
Level A Audit at Location(3) for Period 1513.xls move to … Audit files\Level A Audits
So if 'Level A' appears at the beginning of the file name place it in the Level A audits folder, no matter what the period number is.

B Audit Location(1)14_01.xls move to … Audit files\Level B Audits\Level B Year 14\Level B 1401
B Audit Location(1)14_02.xls move to … Audit files\Level B Audits\Level B Year 14\Level B 1402
B Audit Location(2)14_01.xls move to … Audit files\Level B Audits\Level B Year 14\Level B 1401
B Audit Location(3)15_01.xls move to … Audit files\Level B Audits\Level B Year 15\Level B 1501
B Audit Location(1)15_03.xls move to … Audit files\Level B Audits\Level B Year 15\Level B 1503
If 'B Audit' appears then the first part of the Period number, for example '14_', determines which year folder, this example 'Audit files\Level B Audits\Level B Year 14', and the last part of the period number, example '_01' determines the sub folder, example 'Audit files\Level B Audits\Level B Year 14\Level B 1401'.