Completed

I need a macro to create folders

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.

Skills: Excel

See more: hello i need to create a logo and a name to put on my clothing brand, i need to create a video, what do i need to create developer android app company, excel, visual basic for apps, microsoft excel, who do i need to create xml feed, i need to create a logo for my business, know i need to create website, how can i develop my own website or what do i need to create a website, how do i need to create online shopping website, how much do i need to create a website, how much money i need to create an ecommerce website, i need help create a fyler, i need to create a business logo, i need to create a concierge website, i need to create a design, i need to create a flyer, i need to create a leave excel sheet, i need to create a logo

About the Employer:
( 0 reviews ) Perth, Australia

Project ID: #19900801

Awarded to:

paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application with macros that will create folders and subfolders based on More

$400 AUD in 5 days
(187 Reviews)
7.2
supergana

Hi - The requirement is pretty straight forward and involves nesting rules in a structure. I have executed projects that require such mass creation of folders and even contents within these folders. So i have the utili More

$412 AUD in 10 days
(25 Reviews)
4.8

15 freelancers are bidding on average $495 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$588 AUD in 3 days
(689 Reviews)
8.4
seaanddream

Hi, my name is Selim. I am from UK. I read your `I need a macro to create folders` project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soo More

$500 AUD in 5 days
(268 Reviews)
7.7
PigtailXL

Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using d More

$590 AUD in 5 days
(168 Reviews)
7.1
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed More

$550 AUD in 4 days
(102 Reviews)
7.1
tiaratechies

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.

$750 AUD in 7 days
(51 Reviews)
6.6
shikhamehta

Hey, I am an expert in Excel and have done several macros that perform various business functions. I can create a setup for you that will allow to 'import' company data, analyze it and create the folders as desired. More

$800 AUD in 7 days
(95 Reviews)
6.3
dvcontact

Hi, Would you like to see a quick demo of your project on building a macro enabled spreadsheet that will create folders based on whether certain criteria is met completed before you award the project? You can consider More

$500 AUD in 7 days
(47 Reviews)
6.3
periyannas

Ok Sure let me help----------------------------------------------------------------------------------------

$470 AUD in 1 day
(98 Reviews)
6.1
aubrey03

I am an MS Excel and Access Specialist and an experienced Freelancer who is dedicated to provide quality results within a reasonable timeline and budget. Accuracy is my priority so I believe I am the best freelancer fo More

$250 AUD in 2 days
(95 Reviews)
5.7
katiewells3

Hi There As an Australian Business Analyst with over 15 years professional experience building VBA automations I would love the opportunity to work with you on this. It would be great to have a look at the folder / More

$350 AUD in 5 days
(28 Reviews)
5.1
afenache

Hi, I can write the needed VBA script to create all the folders that you need. Best regards, Florin Enache

$500 AUD in 5 days
(19 Reviews)
5.2
mauricemarinus

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

$264 AUD in 4 days
(9 Reviews)
3.9
rickygzz85

I will gladly help you with your project. Please contact me to talk more about your needs. If you are using Windows, maybe we can upgrade the project to a Windows executable with a database, with the option to export y More

$500 AUD in 7 days
(8 Reviews)
3.1