Creating multiple workbooks out of 1 workbook based on column values

Hi excel wizzards

I have only limitted experience with VBA. I've tried some code i've found online, but I dont fully get what to alter to make it work for my particular example.

I have 1 workbook with 1 sheet that I want to split this into multiple workbooks based on a column.
Example attached.
I would like to create seperate workbooks that contain the data for every unique country (column C). So e.g. a file called NLD.xlsx containing only the data for rows for NLD, a file called FRA.xlsx containing only the data for rows for FRA, etc).
Each file should also have the first 5 rows of general information and the headers.

Anyone that could point me to a thread containing code I could use? I found some, but these are based on a column containing specific values and i dont know which country names may be included in column C.
So I think I need to create a collection containng the unique country values and loop through those by filtering the data, but I'm not sure how.

(I will eventually want to create a seperate xlsm that has a button to push, which will allow to select a source file to load that then will be split, but I think i should be able to find code for that piece).

Apprieciate any help!

Try

Please Login or Register  to view this content.

You, good sir, are a hero. Works like a charm.

Could you explain a little to me what the code is doing, because this is deffintily a step further than what I started with. Perhaps add some guidance text? Just so I know how to change it for different scenario's.
E.g.
- If I dont know the sourcesheet's name in advance, I believe I can update 'With Sheets("blad1")' to 'With Sheets (2)' right? (this seems to work in any case).
- If the Country values, would be in a different column (not c), how would I update the code? I've tried updating "a = .Columns("c").Value" to another column, which still creates correct file name, but they are without data.
- If the precedeing general section would fo example be larger and table would start in row 8 (not 6), how would I need to update the code in that case?

Thank you so much for helping me out!

Please Login or Register  to view this content.

Hi

I now have a data set that does not have the empty row. so all first 5 rows have something in it.
The rest is the same, with the header row still being ow six. Is there a way to change the above code for this situation? perhaps adding an empty row and taking it back out before saving?

Originally Posted by Sirilias

perhaps adding an empty row and taking it back out before saving?

Correct,

Please Login or Register  to view this content.

and delete at the end

Please Login or Register  to view this content.

Hi Jindon,

Perfect. I made an additional edit to also get the output to not have the empty row, works perfectly!
Thanks so much!

Please Login or Register  to view this content.