Write an Excel Macro / Build a program to automatically generate invoices from a pool of data
This project was successfully completed by maverick44000 for $2000 AUD in 5 days.Get free quotes for a project like this
Project Budget$1500 - $3000 AUD
Completed In5 days
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online