need a VBA program to generate report

$10-135 USD

Completed

Posted

about 6 years ago

$10-135 USD

Paid on delivery

A short summary: - generate report from a report template, by looking up the relevant data in some worksheets - The report has around 30 rows (they all have same logic, with 1 to 2 special cases), and you need to look up values in another 2 sheets to fill in those - I'm a developer myself, so I have already written out a detailed and logical instructions on how to fill in those values. - I'll also need you to write test cases to show the correctness of your program. I expect there are around 20 test cases to cover majority of the scenario - I only need a very simple UI. I'm ok with a simple dialog, with one dropdown selection and one button. The user click on the button, then the report is generated in another worksheet. [I'll have around 2 to 3 more similar reports that needs to be done if this first task is done well]

Excel

Visual Basic

Visual Basic for Apps

Project ID: 16441030

About the project

17 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards.

$135 USD in 12 days

5.0

(21 reviews)

4.4

17 freelancers are bidding on average $37 USD for this job

@schoudhary1553

Dear Sir, I have gone through your project details and understand that you need a VBA program to generate report. I have 5 years of experience in Excel, Visual Basic, Visual Basic for Apps I will make A PROGRAM that will generate report from a report template, by looking up the relevant data in some worksheets Kindly ping me to discuss further details.

$30 USD in 1 day

4.9

(222 reviews)

7.3

@P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD in 1 day

4.9

(234 reviews)

6.9

@avinav606lx

Hi there, I am an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman

$55 USD in 1 day

4.9

(154 reviews)

6.4

@vlayausa

Hello, I am proficient with Excel and VBA. I also have a lot of experience with making macros similar to what you described. I would love to help with this project. Please contact me for more information.

$25 USD in 1 day

4.9

(123 reviews)

5.7

@usmanhassan123

A proposal has not yet been provided

$30 USD in 1 day

4.8

(24 reviews)

5.1

@AkilaArun

Hi, I would like to discuss on the task. I have good experience working with Excel. It would be great if you can share the file along with requirement which will give a much better idea of the exact expectation. Looking forward to hear from you. Best Regards, Akila.K

$30 USD in 1 day

5.0

(24 reviews)

4.3

@vivirain

A proposal has not yet been provided

$30 USD in 1 day

4.9

(10 reviews)

3.7

@nelumindralal

Hello Sir, I went through the description Kindly send me the document and will complete it today I have did similar project earlier such as automatically job report creating from excel to pdf and email, automatically generated pivot tables, FIFO calculation to calculate actual cost, etc Please review my past jobs and will do perfect job for you cost can be negotiated I am looking forward to hearing from you my key values to the clients are Delivery on time, Competitive price and perfect quality Thanks regards Thushara

$30 USD in 1 day

5.0

(11 reviews)

3.8

@sloker18

I am proficient in using excel macro/VBA, I hope we can discuss more in detail regarding your project over the chat, I assure your project will be delivered in high quality. Await for your precious reply.

$25 USD in 1 day

5.0

(3 reviews)

2.9

@ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget.

$25 USD in 1 day

4.7

(11 reviews)

2.8

@pku567b8e0ff0216

hi have done already this type of project easly there is no any problem in this i think i am best man for this project i have 3 yeasr of exprerince in microsoft technology in cluding vb.net excel .

$25 USD in 1 day

0.0

(0 reviews)

0.0

@raviindore

Hi there! I think I would be right fit for your job. Have done excel projects where used VBA programming to process data/to generate report. (See screenshots of Attendance System and Data Profiling projects in my profile). I have also worked as software tester for 5 yrs. So always test my solutions thoroughly.

$30 USD in 2 days