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

Encerrado

Descrição

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

Ver 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

ID do Projeto: #12306384

Premiar a:

maverick44000

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
(64 Avaliações)
6.6

45 freelancers estão ofertando em média $1893 para este trabalho

$2500 AUD in 15 dias
(394 Comentários)
7.7
$1500 AUD in 7 dias
(245 Comentários)
7.6
deepbluetech

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
(159 Comentários)
7.0
seaanddream

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
(199 Comentários)
7.1
cgullapalli

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
(353 Comentários)
7.2
aarifakhtar

Hi: I have done a few similar projects. Here is an example: https://www.freelancer.com/projects/Excel/Monthly-Report-Creation-need-program/ .Also, I would like to highlight that you have missed to attach the files (me Mais

$1500 AUD in 10 dias
(132 Comentários)
6.7
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.

$2000 AUD in 10 dias
(124 Comentários)
6.4
cugamelover

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
(128 Comentários)
6.6
chriskerpini

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
(53 Comentários)
6.2
paris2785

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
(102 Comentários)
6.2
dpune

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
(102 Comentários)
6.1
schoudhary1553

A proposal has not yet been provided

$1500 AUD in 30 dias
(105 Comentários)
6.1
rengrish

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
(120 Comentários)
5.7
macroPOL

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
(59 Comentários)
5.5
wsh2

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 Mais

$1866 AUD in 30 dias
(27 Comentários)
5.7
NallakumarKC

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)
5.2
sonarkaushik

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
(39 Comentários)
5.5
satishtl

- 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
(27 Comentários)
4.6
citijayamala

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 Mais

$1666 AUD in 30 dias
(33 Comentários)
4.8
serdaryalcin

Hi, First of all your budget is too high for the project. I can do it for half of the price. Please adjust your budget so I can decrease my price. It is easy, I have examples to share, and my solution will be Mais

$1500 AUD in 5 dias
(19 Comentários)
4.2