Encerrado

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

Este projeto recebeu 48 ofertas de freelancers talentosos com uma oferta média de preço de $1879 AUD.

Obtenha orçamentos gratuitos para um projeto como este
Empregado trabalhando
Orçamento do projeto
$1500 - $3000 AUD
Total de Ofertas
48
Descrição do projeto

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.

Querendo fazer dinheiro?

  • Defina seu orçamento e o prazo de entrega
  • Descreva sua proposta
  • Receba pelo seu trabalho

Contratar freelancers que também ofereça neste projeto

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