Write an Excel Macro / Build a program to automatically generate invoices from a pool of data

Hi. Each week I make a series of financial reports in Excel. Currently I manually make the reports by copy and pasting data from my booking system back in to excel.

I have a way of extracting all the data from the website via CSV. I would like to create some kind of macro that when I click a button, it pulls all the data from the CSV and creates these reports for me.

An example of the CSV file and a dummy report is attached.

In the excel file you will see there is a new Sheet for every cleaner. The idea of the macro would be to create that sheet for every cleaner, which has all the job details (day, address, job total, service etc) of the jobs they did.

My company is growing quickly so we regularly have new cleaners and therefore I would like to be able to add to the macro too (so if a new cleaner comes to work I can include them in the macro and have a report made for them too).

Probably easiest to talk this over so please try and scale the price and let me know and we can discuss further.

Skills: Database Development, Database Programming, Excel

See more: excel macro build freelancer, data entry program excel, entry data dalam program excel, write file macro excel, macro excel write word, data connection odbc excel macro vba, write macro excel, need someone write vba macro excel, data internet explorer excel macro, write text macro excel, excel macro generate data, excel macro build chart, copying data ms projects excel macro, copy data column column excel macro, excel macro copy data program, excel macro file write, write macro excel control internet explorer, write macro excel uses internet window, data entry form excel macro, excel macro example write clipboard, write macro excel lotto, paste data cell content excel macro, run external program excel macro, macro excel open sort output, show print macro excel

About the Employer:
( 7 reviews ) Brunswick East, Australia

Project ID: #12306384

Awarded to:


Hi Sir, I have gone through the project description and though you forgot to attach the file, I have a pretty good idea about your requirement. The Excel model will allow you to add more workers without making a mod More

$2000 AUD in 5 days
(67 Reviews)

44 freelancers are bidding on average $1902 for this job

$2500 AUD in 15 days
(477 Reviews)

Hi, I am good at Excel and vba. I have gone through the details. Looking forward to discuss further about the internals of the project with the csv and report template across tables.

$2000 AUD in 7 days
(498 Reviews)
$1500 AUD in 7 days
(250 Reviews)

Hi, my name is Sevinc. I read your "Write an Excel Macro / Build a program to automatically generate invoices from a pool of data" project descriptions carefully before bidding. I checked your requirements as well... More

$1500 AUD in 5 days
(223 Reviews)

Hi, I am an Excel macro expert and would be happy to take on your project. Please share specific details and we can discuss. Regards, Arul

$2000 AUD in 7 days
(162 Reviews)

A proposal has not yet been provided

$1500 AUD in 30 days
(178 Reviews)

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, More

$1500 AUD in 10 days
(151 Reviews)

Hi: I have done a few similar projects. Here is an example: .Also, I would like to highlight that you have missed to attach the files (me More

$1500 AUD in 10 days
(138 Reviews)

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.

$2000 AUD in 10 days
(181 Reviews)

Hello, My name is Chris. As you can see from my profile, I have 16+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. There is More

$1670 AUD in 10 days
(55 Reviews)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y More

$1500 AUD in 10 days
(117 Reviews)

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea More

$2500 AUD in 15 days
(110 Reviews)

Hello, I am Excel and VBA expert. Can you provide the files (files have not been attached to the project) Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$1500 AUD in 10 days
(60 Reviews)

Unfortunately, your examples are not attached to the project. No problem. At your earliest convenience, could you please attach your example(s) to a private chat message and send, so we may better analyze and discuss y More

$1866 AUD in 30 days
(28 Reviews)

Hi , I have done many such similar job. I can do this job for <250$ totally time line 1 or 2 days or even few hours . MY bid would be very less when compared to others. I have 10+ years of experience in Excel & VBA. More

$1500 AUD in 2 days
(127 Reviews)

- Can get the invoices generated from the csv per cleaner on click of a button. - Have done similar financial transactions extraction and summarising into individual tabs. - Have expertise in Excel automation, macr More

$1500 AUD in 5 days
(39 Reviews)

Hi, I am Nallakumar. I have more than 10 years of experience in Excel Automation. I am not seeing any attachments in the project. We will create a template, that will have a button on it and some predefined sh More

$2300 AUD in 10 days
(7 Reviews)

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. More

$1556 AUD in 15 days
(40 Reviews)

I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.

$1500 AUD in 30 days
(34 Reviews)

Expert in Excel, Excel formulas, and all excel functions, macros, lookup concepts. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Can complete on time with More

$1666 AUD in 30 days
(40 Reviews)