Need help splitting a xlsx file

[JilVW]

I have received an .csv file and saved this file as an .xlsx file because otherwise my Java program couldn't work with it.
I don't have enough memory to work with the .xlsx file through Java (because the file is 19 MB).
I would like to split the .xlsx file into several .xlsx without having to copy paste all of it.

My Excel file looks like this:

clip_image002.jpg

clip_image002.jpg

splitsen.png

I would like to have a seperate file for each TRAIN_NUM. Is this possible and can somebody tell me how? (I have no experience with macro's.)
Each TRAIN_NUM can have a different amount of rows and the TRAIN_NUMs are not always consecutive.

[JilVW]

Does anyone know the answer?

[HaHoBe]

Hi, JilVW,

maybe you can adapt the code from http://www.excelforum.com/excel-prog...ml#post3404668 to suit your needs (you would need to work with Column B instead of Column A which means Autofilter would have to be applied on Column 2 instead of 1).

Ciao,
Holger

[JilVW]

Ok, I have used this code and changed it to the second column (A to B)

Please Login or Register  to view this content.

But when I run this, then I only get a file with one line in. I need a file for each train number with all the data from that train number (so not one, but several lines).
Is it also possible to choose the name of the files that are generated?

Thanks!

[HaHoBe]

Hi, JilVW,

if my Exccel could convert your pictures to worksheets I think I could figure out what is going wrong with the code. So maybe you can attach a worbook instead of pictures?

Ciao,
Holger