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.

Habilidades: Desenvolvimento de Banco de Dados, Programação de Banco de Dados, Excel

Veja mais: 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

Acerca do Empregador:
( 7 comentários ) Brunswick East, Australia

ID do Projeto: #12306384

Concedido a:


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 Mais

$2000 AUD em 5 dias
(67 Comentários)

43 freelancers estão ofertando em média $1903 para esse trabalho

$2500 AUD in 15 dias
(563 Comentários)

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 dias
(686 Comentários)

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... Mais

$1500 AUD in 5 dias
(251 Comentários)

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 dias
(167 Comentários)
$1500 AUD in 7 dias
(250 Comentários)

A proposal has not yet been provided

$1500 AUD in 30 dias
(225 Comentários)

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, Mais

$1500 AUD in 10 dias
(164 Comentários)

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 Mais

$1500 AUD in 10 dias
(152 Comentários)

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 dias
(260 Comentários)

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 Mais

$1670 AUD in 10 dias
(66 Comentários)

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 Mais

$1500 AUD in 10 dias
(138 Comentários)

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 Mais

$2500 AUD in 15 dias
(116 Comentários)

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. Mais

$1500 AUD in 2 dias
(134 Comentários)

- 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 Mais

$1500 AUD in 5 dias
(43 Comentários)

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 dias
(61 Comentários)

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. Mais

$1556 AUD in 15 dias
(42 Comentários)

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 Mais

$2300 AUD in 10 dias
(7 Comentários)

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 dias
(37 Comentários)

I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a reservation system - Built a complex shift allowance c Mais

$1500 AUD in 15 dias
(31 Comentários)

Hi, I am an Australian-based Excel developer with extensive experience in creating Excel templates to import data from outside sources and apply calculations/reformat this data. I believe I should be able to create Mais

$2000 AUD in 15 dias
(47 Comentários)