Find Jobs
Hire Freelancers

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

$1500-3000 AUD

Concluído
Publicado há aproximadamente 7 anos

$1500-3000 AUD

Pago na entrega
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.
ID do Projeto: 12306384

Sobre o projeto

41 propostas
Projeto remoto
Ativo há 7 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
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 modification to the macro. I am a highly skilled Excel and VBA freelancer and have developed many similar projects before. Please take a look at my past work and clients feedback. This work requires no more than 5 days to complete and you can give it a test before making the payment. Please discuss via chat and send the file over so I may have a look at exact data. Thank you, Usman
$2.000 AUD em 5 dias
5,0 (73 avaliações)
6,9
6,9
41 freelancers estão ofertando em média $1.919 AUD for esse trabalho
Avatar do Usuário
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 your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$1.500 AUD em 10 dias
5,0 (606 avaliações)
8,6
8,6
Avatar do Usuário
A proposal has not yet been provided
$1.500 AUD em 30 dias
4,9 (533 avaliações)
8,4
8,4
Avatar do Usuário
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.
$2.000 AUD em 7 dias
5,0 (1205 avaliações)
8,4
8,4
Avatar do Usuário
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.
$2.000 AUD em 10 dias
5,0 (491 avaliações)
8,0
8,0
Avatar do Usuário
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... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$1.500 AUD em 5 dias
5,0 (303 avaliações)
8,1
8,1
Avatar do Usuário
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
$2.000 AUD em 7 dias
5,0 (173 avaliações)
7,4
7,4
Avatar do Usuário
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 (mentioned in the project brief). Please note that over 80% of completed projects are related to Excel and Macro. Moreover, I have ~100% completion rate and 5-star feedback on projects. Please connect with me to discuss your requirements in detail.
$1.500 AUD em 10 dias
4,9 (168 avaliações)
7,1
7,1
Avatar do Usuário
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, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Just FYI, I own a small business registered in the state of Illinois, USA. I could bill you as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$1.500 AUD em 10 dias
4,8 (179 avaliações)
7,2
7,2
Avatar do Usuário
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 no any attachment in your post, however, I understand what you want to achieve. Of course I can't provide a detailed proposal without seeing the Excel file and without knowing all the details. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chris (chriskerpini)
$1.670 AUD em 10 dias
4,9 (71 avaliações)
6,6
6,6
Avatar do Usuário
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 good quality and on time. Expert in referencing and will deliver work with no plagiarism. Experienced MBA Finance as well.
$1.666 AUD em 30 dias
4,8 (93 avaliações)
6,3
6,3
Avatar do Usuário
I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.
$1.500 AUD em 30 dias
4,9 (52 avaliações)
6,2
6,2
Avatar do Usuário
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.
$1.500 AUD em 10 dias
5,0 (93 avaliações)
6,1
6,1
Avatar do Usuário
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. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$2.500 AUD em 15 dias
4,9 (120 avaliações)
6,3
6,3
Avatar do Usuário
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. Please check my past reviews and ratings. Please ping back to discuss the requirements , so that I can propose the solution and bid accurately. Why i should be Hired ? I have very good experience 100% accurate solution 100% Time compliance Good Communication I am sincere,honest and hardworking independent freelancer. I give more importance to the job than $. Please let me know your email id for ease of communication . Thank You. Regards, Rishi
$1.500 AUD em 2 dias
4,9 (160 avaliações)
6,0
6,0
Avatar do Usuário
I have experience in Excel, VBA, Macros, Formulas, Pivot Tables, Charts for data analysis and processing. I will be glad to help you in your project in Excel. Alternatively, I am also able to make an Access Database of the same if you also prefer that option, as it scales quite well when you add new workers. Either way I can the solution as you require with reports. I am also capable of integrating reports to powerpoint/word should this be in your future requirements. PM for more discussions. We can discuss project milestones. For the description in your requirements, I propose 700AUD
$1.500 AUD em 10 dias
4,9 (67 avaliações)
5,7
5,7
Avatar do Usuário
- 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, macros, formulas, calculations, summarising and Graphs. - Excel macros - I have done complicated data processing using Excel macros for Exam sheet evaluation, (Recent)Circuit designing based on mulitple wire models, amps/voltages, calculations of taxes for Canadian citizen based on tax slabs per Fed and Provincial tax, based on the salary ranges etc. - Outlook macros - - Samples - Extracting mail contents parsing and sending to different customers, getting the task and calendar events from Outlook to Excel - Pl. review my portfolio on recent projects. My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
$1.500 AUD em 5 dias
4,6 (52 avaliações)
6,1
6,1
Avatar do Usuário
Hello, I can't see any attached files. Please upload your samples. I'm ready to start working on your project.
$1.500 AUD em 30 dias
5,0 (10 avaliações)
5,8
5,8
Avatar do Usuário
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a reservation system - Built a complex shift allowance calendar and calculator - Built a complex lookup to sort products into multiple categories You can see the reviews of the same in my profile
$1.500 AUD em 15 dias
4,8 (81 avaliações)
5,9
5,9
Avatar do Usuário
Hello Good Day, After having a look into your project description it looks like perfect fit for our skill sets. as you mention you need an Excel macro that pull the data from CSV file and generate the Report. We have an Excel Expert in My team and I'm sure We can do it as per your requirement. Let's discuss in further details. Thank you and looking forward to have an opportunity to work with you. SAM
$1.666 AUD em 15 dias
4,7 (45 avaliações)
5,5
5,5
Avatar do Usuário
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. with thanks and regards
$1.556 AUD em 15 dias
4,6 (43 avaliações)
5,6
5,6

Sobre o cliente

Bandeira do(a) AUSTRALIA
Brunswick East, Australia
4,9
7
Método de pagamento verificado
Membro desde abr. 22, 2014

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.