Finalizat

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

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.

Aptitudini: Dezvoltare Baze de Date, Programare baze de date, Excel

Vezi mai multe: excel macro build freelancer, data entry program excel, entry data dalam program excel, write file macro excel, macro excel write word, data connection odbc excel macro vba, write macro excel, need someone write vba macro excel, data internet explorer excel macro, write text macro excel, excel macro generate data, excel macro build chart, copying data ms projects excel macro, copy data column column excel macro, excel macro copy data program, excel macro file write, write macro excel control internet explorer, write macro excel uses internet window, data entry form excel macro, excel macro example write clipboard, write macro excel lotto, paste data cell content excel macro, run external program excel macro, macro excel open sort output, show print macro excel

Despre angajator:
( 7 recenzii ) Brunswick East, Australia

ID Proiect: #12306384

Acordat lui:

maverick44000

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 mod Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% AUD în 5 zile
(67 Recenzii)
6.7

43 freelanceri licitează în medie 1903$ pentru acest proiect

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 15 zile
(563 recenzii)
8.2
cgullapalli

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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 7 zile
(686 recenzii)
7.7
seaanddream

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... Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 5 zile
(251 recenzii)
7.5
deepbluetech

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 7 zile
(167 recenzii)
7.3
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 7 zile
(250 recenzii)
7.6
schoudhary1553

A proposal has not yet been provided

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 30 zile
(225 recenzii)
7.4
cugamelover

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, Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 10 zile
(164 recenzii)
7.0
aarifakhtar

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 (me Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 10 zile
(152 recenzii)
6.9
P0L

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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 10 zile
(260 recenzii)
7.0
chriskerpini

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 10 zile
(66 recenzii)
6.5
paris2785

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 y Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 10 zile
(138 recenzii)
6.6
dpune

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. Plea Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 15 zile
(116 recenzii)
6.2
rengrish

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. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 2 zile
(134 recenzii)
5.8
satishtl

- 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, macr Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 5 zile
(43 recenzii)
5.5
macroPOL

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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 10 zile
(61 recenzii)
5.6
sonarkaushik

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. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 15 zile
(42 recenzii)
5.6
NallakumarKC

Hi, I am Nallakumar. I have more than 10 years of experience in Excel Automation. I am not seeing any attachments in the project. We will create a template, that will have a button on it and some predefined sh Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 10 zile
(7 recenzii)
5.2
KavTan

I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 30 zile
(37 recenzii)
5.4
archanaoswal

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 c Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 15 zile
(31 recenzii)
5.0
DMcCarthy89

Hi, I am an Australian-based Excel developer with extensive experience in creating Excel templates to import data from outside sources and apply calculations/reformat this data. I believe I should be able to create Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 15 zile
(47 recenzii)
5.1