using excell to copy documentation

[cadmancolin]

Problem

When we start a new project we copy the master template folder into a new location rename that folder to the contract number then delete out all the files not required for that particular project since their is over a 1000 files to copy/ delete i have been thinking of a different method

this is what i want to do is have a spreadsheet with a full list of all the files in the template project

in column "A" will be the file name in column "B" will the the full path name column "C" will be a yes/no cell if the file is used

column "d" with be brief description of the file

two more cells are used cell 1 will have the project name in cell 2 will be the location where the folder will be created

so this is the work flow

1) Enter the project name
2) Enter the folder location
3) Go down the list and select yes if you require this file no if its not required
4) Hit a go button which will launch a macro this macro will then create a folder in the location stated

Then it will then work its way down the list when it finds a cell with yes as the value then the macro will copy the file in that row to the project location specified

now since my VBA/macro writing is almost zero is there anybody out there or another posting that can point me in the right direction ?
attached is a basic idea of how i would like the spreadsheet to look

demo.xls

Thanks

Colin

[nathansav]

https://www.google.co.uk/?gws_rd=ssl...ba&safe=images

https://www.google.co.uk/?gws_rd=ssl...ba&safe=images