I want to create a spreadsheet that allows a company to be assessed against a benchmark. The assessment will consist of a checklist so the user can specify if that criteria applies to the company or not, e.g. does the company operate in USA, does the company make widgets, etc.? These will be binary yes / no responses.
If the answer is yes, then I need a folder to be created in C drive so that information relating to that criteria can be stored. In nearly every case, if the criteria is met then additional sub-folders will also have to be generated - for example, does the company have insurance (answer, yes) so an "Insurance" folder will be generated on C Drive, together with sub folders "Current", "Historic" and in each sub folder there will be further sub-folders for each type of insurance (e.g. public liability, workers compensation etc.)
I have a full list of the folder / sub-folder structure that a macro could refer to.
As different criteria will apply for each different company the spreadsheet will have to develop a different set of folders each time. Some companies may only need a few folders / sub-folders, others may need thousands (i.e. if there are lots of subsidiaries)
I think I need an Excel workbook that contains macros to;
Writes to cells dependent on number of items (i.e. if there are 50 subsidiary companies connected to the main company, then the macro will write "Company #1 to one row, Company #2 to next etc.) User should be able to define the number of items, and the naming convention.
Check if condition is met on worksheet
If condition is met, to create folder in C:\Test with a file name that matches the cell.
Happy to discuss, provide more details as necessary.
15 freelancers are bidding on average $495 for this job
Hello, I'm an advanced excel expert that can create your requirement as required, but before going forward i would like to see the condition criteria in the template.
Hi. Well... macros.. not necessarily. I would love to do this project for you. I have over 18 years developement experience. Can we discuss this later? Gotta run and take the kids to school Maurice