Mikeymike_W
Board Regular
- Joined
- Feb 25, 2016
- Messages
- 171
Hi All,
I am looking for excel to create a file structure with a parent folder and sub folders which will contain a couple of other excel documents, the trigger for this would be when a new entry is made within the spreadsheet. A new entry is made using a userform.
I have quite a large spreadsheet but for simplicity sake lets assuming the following:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Column A - Market[/TD]
[TD]Column B - Centre[/TD]
[TD]Column C - ID[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[TD]Sydney[/TD]
[TD]GHTY6745[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Hamburg[/TD]
[TD]UIFG98078[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]Nancy[/TD]
[TD]RTYU5634[/TD]
[/TR]
[TR]
[TD]UK[/TD]
[TD]Birmingham[/TD]
[TD]YU6734[/TD]
[/TR]
</tbody>[/TABLE]
I want to create a Parent Folder which be located in the path \\LISA\Case (and at the end of the file path name will be the market name & "" centre name)
It will then put a sub folder within the folder above which will be named "ID" & "Centre"
Then within this folder two more sub folders called "Design" & "Planning"d
Within the Planning folder I'd like another excel file to be placed within.
If either the market file and\or the centre file does not exist then it would be great if it recognised this and created these two folders aswell.
This seems like a lot to ask but I'm hoping someone can help cause I have absolutely no idea!!
I am looking for excel to create a file structure with a parent folder and sub folders which will contain a couple of other excel documents, the trigger for this would be when a new entry is made within the spreadsheet. A new entry is made using a userform.
I have quite a large spreadsheet but for simplicity sake lets assuming the following:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Column A - Market[/TD]
[TD]Column B - Centre[/TD]
[TD]Column C - ID[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[TD]Sydney[/TD]
[TD]GHTY6745[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Hamburg[/TD]
[TD]UIFG98078[/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD]Nancy[/TD]
[TD]RTYU5634[/TD]
[/TR]
[TR]
[TD]UK[/TD]
[TD]Birmingham[/TD]
[TD]YU6734[/TD]
[/TR]
</tbody>[/TABLE]
I want to create a Parent Folder which be located in the path \\LISA\Case (and at the end of the file path name will be the market name & "" centre name)
It will then put a sub folder within the folder above which will be named "ID" & "Centre"
Then within this folder two more sub folders called "Design" & "Planning"d
Within the Planning folder I'd like another excel file to be placed within.
If either the market file and\or the centre file does not exist then it would be great if it recognised this and created these two folders aswell.
This seems like a lot to ask but I'm hoping someone can help cause I have absolutely no idea!!