PrinceOfDarkness
New Member
- Joined
- Nov 10, 2018
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Dear Excel friends,
Sorry for asking sort of the same question like many have before me. Of course I searched the internets but can't find a solution that meets my query, maybe one of you could help me? I am in the learning process of VBA but I am not that skilled to create it myself although I can pretty much alter existing codes.
I even find it hard to put the question in words so I thought maybe two images would speak for itself... I hope...
This is my range I have in the Excel sheet:
This is the output I'd like:
There are few things that make this such a pain:
1. Sometimes the Country is not known, so the cell value for Country is empty.
In that case the cell value of City goes direct under the root folder World.
2. Sometimes the City folder is not known, so the cell value for City is empty.
In that case the cell value of Number goes direct under the Country folder (if known) otherwise in the root folder World.
3. The amount of Number varies every project but does not exceed 50.
Last but not least, I have a folder (with contents) called Basic which is stored here: C:\Temp\Basic\.
In any of the numbered folders (in this example folders 1-18) should be copied the Basic folder.
I am very sorry for posting such difficult request but on the other hand you may find yourself a challenge over here
Basically if you look at it in reverse it is (in this example) the creation of 18 numbered folders divided by city and again divided by country.
Thanks for helping me out with this one!
Sorry for asking sort of the same question like many have before me. Of course I searched the internets but can't find a solution that meets my query, maybe one of you could help me? I am in the learning process of VBA but I am not that skilled to create it myself although I can pretty much alter existing codes.
I even find it hard to put the question in words so I thought maybe two images would speak for itself... I hope...
This is my range I have in the Excel sheet:
This is the output I'd like:
There are few things that make this such a pain:
1. Sometimes the Country is not known, so the cell value for Country is empty.
In that case the cell value of City goes direct under the root folder World.
2. Sometimes the City folder is not known, so the cell value for City is empty.
In that case the cell value of Number goes direct under the Country folder (if known) otherwise in the root folder World.
3. The amount of Number varies every project but does not exceed 50.
Last but not least, I have a folder (with contents) called Basic which is stored here: C:\Temp\Basic\.
In any of the numbered folders (in this example folders 1-18) should be copied the Basic folder.
I am very sorry for posting such difficult request but on the other hand you may find yourself a challenge over here
Basically if you look at it in reverse it is (in this example) the creation of 18 numbered folders divided by city and again divided by country.
Thanks for helping me out with this one!