Split a workbook into different workbooks base on conditions

Hello all.
I'm having some trouble creating a macro to split a file into smaller and different ones.
This is how to main file looks like:

gvf_example_database.xlsx

What I want to achieve is:
1- Select, in the first column, a country
2 - Select, in the second column, a year
3 - Select, in the third column, a specification
4 - save that on a specific folder, preferably in the "specification_year_country.xls" format
5 - loop through all the possible combinations of specification, year and country, and create the file

I've been trying to implement solutions that i've found on the internet, but to no use...
I appreciate any help.
Thank you.

Gvf

Its better to attach a sample excel file than a jpg. It will save us a lot of time in replicating the jpg.

So ideally there will be 11*4*10 = 440 different workbooks with data to be created?

Hi gvf
This code is in the attached. I see some issues with non-printable characters and some fields being empty but perhaps you've anticipated this. In any event, see if this is what you have in mind. Let me know of issues.

Please Login or Register  to view this content.