Write an Excel Macro / Build a program to automatically generate invoices from a pool of data
Acest proiect a primit 48 oferte de la freelanceri talentați, cu o ofertă medie de 1879$ AUD.Obține oferte gratuit pentru un proiect similar
Buget proiect$1500 - $3000 AUD
Nunăr total de oferte48
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.
Vrei să câştigi niște bani?
- Setează-ți bugetul și intervalul de timp
- Schițează-ți propunerea
- Fii plătit pentru munca ta
Angajează freelanceri care au plasat oferte și la acest proiect
Cauți de lucru?
Lucrează la proiecte similare și câştigă bani de acasă!Înscrie-te acum
- The New York Times
- Wall Street Journal
- Times Online