Completado

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

Este proyecto fue completado exitosamente por maverick44000 por $2000 AUD en 5 días.

Obtén cotizaciones gratis para un proyecto como este
Presupuesto de Proyecto
$1500 - $3000 AUD
Completado En
5 días
Ofertas Totales
45
Descripción del Proyecto

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.

Completado por:

Buscando hacer algo de dinero?

  • Establece tu presupuesto y período de tiempo
  • Describe tu propuesta
  • Consigue pago por tu trabajo

Contrata Freelancers que también oferten en este proyecto

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online