Macro to Split 1 worksheet to Multiple Excel Files - with Name of Cell (Column).

[Jennie82]

Dear Experts in Excel,

I am making reports and facing an issues with large volumes.
The file is about 25,000 items belongs to 305 students. Each student can have datas in multiple Rows.

The Student Name are in column (L : Student as its header). I cannot manually copy data for each student manually to create a seperate file for him/her and naming the file as his/ her name.

I would like to have a Macro to help me with this.
I am quite new to VBA so I can hardly understand the previous posts on this matter . Appreciate your Support.


Best Regards,

Thu.

 

[JLGWhiz]

Hi JLGWhiz, it is really lucky that you can read my post and help. I understand the request is quite funny for 305 files but it is a real request I received. Thank you for your help. Many people can find this interesting .

You're welcome,
Regards, JLG