In Progress

VBA Excel Application


We need a MS Excel VBA application that consolidates several excel files into one single file and generate some statistic graphics based on the data contained in the imported files.


MS Excel 2010

Only one file no external executable, ActiveX or dll in order to easily distribute and run on any workstation that has MS Excell installed without any further installation.

Each Sheet shall show a company logo

Sample input excel file will be provided to programmer selected.

Structure of the Application:

1. Sheet 1: Opening file in Excel shows a welcome sheet with login facility and link to admin section.

2. Sheet 2: Admin sheet only visible and accessible if admin is logged in

3. Sheet 3: File Import sheet

4. Sheet4-…: Data of imported files. (As many as required one for each sheet in every file)

5. Sheet (Following the data sheets): Statistical graphics, one per data sheet.

6. Sheet (Last): All graphics onto one page

Admin section (Sheet2)

Password protected offering following functionalities:

- Master password to enter Admin section is placed somewhere in the code and can’t be changed by the user.

- User management to define user access and user rights ‘Admin’ and (‘Read only’ or ‘read write’).

- Data source location (Drive / Path) input field with path browse button.

- Input fields for comment or description that will be shown on logging sheet. (Sheet 1)

Login facility (Sheet1)

Only user defined by the admin can view data sheets, import data or print reports.

Show description edited in admin area.

Data import section (Scheet3)

A combo box shows all available subdirectory located under ‘Data source location’ (See Admin section)

Once a file location is selected the contained file shall be listed on the sheet and an import button shall be activated. There will be up to 10 files in one directory. The file of only directory will be imported at once.

Before new data are imported previously imported data sheets shall be deleted as well as all reports sheets.

A button (import button) to initiate importing excels files contained in the selected subdirectory. The sheets in each imported file shall be stored into one local sheet; the sheets shall be named using filename and sheet name of source file. All data shall be copied not referenced.

Normally report shall be generated automatically after import is done, however a button ‘Generate Reports’ shall be available in order to generate report again.

Before generating new reports all existing reports sheets shall be removed.

Report generation Subtask of data import

Report generation shall be done automatically after importing source files.

Each data sheet shall have a report sheet.

The report sheet shall be named same as the corresponding data sheet and ‘_report’ as additional suffix.

For logged in user with writing permission:

Each report Sheet shall have an additional editable comment input area.

One Overview report shall be available too showing and all other reports including they’re comments onto one page

Printing functionality

Each report sheet shall have a print button to print the Report graphic and the comment

Skills: Excel, Visual Basic for Apps

See more: excel statistic vba, application vba, excel vba application, writing sheets, writing a field report, we excell, visual graphics logo, vba excel programmer, single view application, programmer excel vba, password protected excel, need of excel programmer, need of data structure to programmer, ms excel programmer, ms access excel vba, master excel 2010, logo of structure management company, logo graphics application, logo for facility management company, logo and graphics generation, generating a company logo, excel to application, excell programmer, define data structure in c, define data structure

About the Employer:
( 8 reviews ) Oberlunkhofen, Switzerland

Project ID: #3977515

Awarded to:


Hi, I am sure I can make the application works as you could imagine. I am a "all the time" 5 stars awarded freelancer and have never failed even for a single project. Feel free to check my profile page.

$250 USD in 5 days
(61 Reviews)

20 freelancers are bidding on average $380 for this job


Excel developer since 1997. Can do. Regards, Svet.

$750 USD in 8 days
(49 Reviews)

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b More

$400 USD in 5 days
(38 Reviews)

Dear softconsultCH, I have studied the requirement and will be able to deliver the work within a week. Let me know.

$300 USD in 7 days
(83 Reviews)

I have a lot of experience with VBA in Excel, as you can see from my project history.

$500 USD in 14 days
(9 Reviews)

Hi, I can do the job, MS Excel expert, VBA programmer Please Check PMB

$250 USD in 7 days
(8 Reviews)

Dear Sir, I am interested to work on this project. I have more than 10 years of exp in software development field. I have good experience in Lotus Notes, VBA, Crystal report, MS SQL and MySQL. I have also good exper More

$250 USD in 7 days
(19 Reviews)

We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.

$250 USD in 4 days
(16 Reviews)

Hi there - I am ready to start this asap, and am very much interested to work on this project with you. I am passionate to work on VBA projects... more in the private message. Regards RF

$750 USD in 15 days
(9 Reviews)

Eager to work with great support army (my niece and nephew- see the profile photo); anxious to have this project done quickly and smoothly in order to get my first review ...

$299 USD in 2 days
(2 Reviews)

GOT A TEAM OF 4 ENGINEERS, will deliver best quality for a reasonable cost...if you are interested,we can talk on neel13191 google mail

$350 USD in 7 days
(1 Review)

Greetings Client, I will be able to help you with your project request. I will provide you with a very robust and accurate project output, I have over 7 years of experience in Excel,Access and VBA and have developed More

$300 USD in 2 days
(1 Review)

Hello, I have great experience in reporting and data consolidation automation in Excel, I'll be glad to complete this project for you.

$250 USD in 14 days
(0 Reviews)

please check pmb.

$700 USD in 8 days
(0 Reviews)

ready to do it ? msg me Am interested just call the expert excel :D

$250 USD in 3 days
(0 Reviews)

Hi, I'm experienced financial analyst and expert VBA developer. I will provide highest quality work. Please check PM, I've sent you a sample to express skills

$400 USD in 6 days
(0 Reviews)

Hello Sir, Please assign your project to us. We are not only good in programming logic but are known for user friendly & simple to understand project. Please see private message. Regards.

$350 USD in 7 days
(0 Reviews)

Greetings! My name is [url removed, login to view] from India. I have completed Batchelor of commerce in 1996. I have strong knowledge in Excel, vba macro, worksheet formula, worksheet events, workbook events, dash board, etc... More

$250 USD in 3 days
(0 Reviews)

Hi, I am an Excel VBA expert and can do the job for you. Thanks!

$500 USD in 3 days
(0 Reviews)

Dear client, I am very interested in your job. I have developed a lot of Excel Macro and Addin with VBA. I am very confident to make you satisfied with my service. Best regards, Joe

$250 USD in 7 days
(0 Reviews)