Filter and save data in a saparate folder

[rasika99]

Guys,

I have excel files that contain the details about exam marks of students. I want to filter data according to "Student No." and save the filtered data in a new work book. A new folder also should be created. Both
the name of new work book and the folder should be the relevant ""Student No.". Since there are many files, the program should identify the "Student No.",filter data, create folders and save filtered data in a new excel work book.

Can i do it using a vba code?

Thank u


Eg.
File Name :- Grade 03

Student No.	Name	Subject	Marks
10	tom	Maths	50
10	tom	Science	49
10	tom	Arts	62
11	harry	Maths	89
11	harry	Science	56
11	harry	Arts	78
12	david	Maths	53
12	david	Science	86
12	david	Arts	75

<tbody>
</tbody>

-----------------------------
The interface i hope to design is a common file that contains vba code and open master data file according to the grade name and then do the filtering and saving part.


Grade Name:.................

Path master file located:...............

Path result file to be saved:.................

------------------------------
Eg.

the result file "10.xls" in the folder named "10" is,

Student No.	Name	Subject	Marks
10	tom	Maths	50
10	tom	Science	49
10	tom	Arts	62

<tbody>
</tbody>