VBA to create folder, subfolder and save workbook

[aaaaa34]

Hello my friends,
I have a file mainlist.xlsx in my folder C:\Database
Inside this mainlist.xlsx file, there is list of cars.
in A column car brandname, B column: model name, C column model year, D column motor volume and E column price
In this manner, I want to have VBA to create folder with a name of A-column Brandname and subfolder B-column Model name
Example:
A1 Peugeot
B1 208
then folder and subfolder should be like this C:\Database\Peugeot\208 and save these rows regarding 208 model as a new workbook 208.xlsx
Please download attached file in the link below and you will see mainlist.xlsx with folders, subfolders and new workbooks inside them.
https://jumpshare.com/v/piJgKwBafKflHGfwQPiy

 

[aaaaa34]

guys
most of u can do it easily, i am sure

 

[aaaaa34]

My friends, I am still waiting you and your replys.

 

[SpillerBD]

No error handling is included...

Sub MakeDirectories()
CntRows = Range("A1").CurrentRegion.Rows.Count

For C = 1 To CntRows
SubA = Range("A" & C).Value
SubB = Range("B" & C).Value

MKString = "C:\Database\" & SubA & "\" & SubB
MK1String = "C:\Database\" & SubA

MkDir MK1String
MkDir MKString

Next C
End Sub

 

[aaaaa34]

No error handling is included...

No bro, it fails.
Please watch the video:İ https://jmp.sh/yz7tvc0
I recorded my screen while applying your VBA

 

[SpillerBD]

I am not able to open your links from my current location.