Find Jobs
Hire Freelancers

Macro for Google Docs to auto generate PDF invoices

€30-250 EUR

Închis
Data postării: aproape 6 ani în urmă

€30-250 EUR

Plata la predare
Dear Freelancers, I am interested in a coder to develop a Macro to ease PDF Invoice generation. We have the data in a Google Spreadsheet. The data records are inserted in Rows in one Sheet and the invoice template is in another Sheet from the same workbook. Please see link below [login to view URL] The Macro should receive as entry parameters the "initial" and "final" number of Invoice to be printed as PDF (on sheet "Macro inputs") Then, macro should populate the fields marked in Blue in sheet "Invoice to PDF" starting by the "initial" number of invoice, export to PDF with a given name "I[INVOICENUMBER]" and iterate until it generates all the PDF within the range "initial" and "final" The spreadsheet provided has demo data to conduct tests We would require documentation explaining how the macro works in case we need to modify any field. Please feel free to contact if more details are needed. Best regards Jaime
ID-ul proiectului: 17065904

Despre proiect

19 propuneri
Proiect la distanță
Activ: 6 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
19 freelanceri plasează o ofertă medie de €145 EUR pentru proiect
Avatarul utilizatorului
Hello, I can help with you in your project Macro for Google Docs to auto generate PDF invoices. I have more than 5 years of experience in Data Processing, Excel, Scripting, Visual Basic . We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
€250 EUR în 3 zile
4,9 (341 recenzii)
8,0
8,0
Avatarul utilizatorului
HI Jaime, I have experience in generating pdf invoices from google spreadsheet. I can generate them to the same folder or a different folder in the google drive. I need the url path of the drive. I have reviewed the document link. I would like to know that the from and to are continuous rows always. Instead of it is better to mention row 2 to 10, etc. My suggestion. Looking forward to work on the project. -Chandra
€100 EUR în 0 zi
5,0 (882 recenzii)
8,0
8,0
Avatarul utilizatorului
Hola, Excel expert at your service. Please check my past reviews for your reference. Looking forward for your reply so that i can start with the implemntation. Telo
€200 EUR în 2 zile
4,9 (339 recenzii)
7,7
7,7
Avatarul utilizatorului
Hello Jaime, I have read your project description and I have 5 years experience in google sheets script programming. I can complete this task within time with 100% accuracy.I am very responsible towards our clients. I know my client needs and importance. Skills : Excel, Macros,VBA,Web scraping,Web Search, Data entry, Copy typing, Transcription works,Wordpress,Megneto,Woocommerce,Shopify,Prestashop etc With Regards, Bhaskar.
€75 EUR în 3 zile
4,9 (458 recenzii)
7,5
7,5
Avatarul utilizatorului
Hola Jaime, mi nombre es Cristian, y trabajo con Excel y GSheets todos los días. Tengo mucha experiencia con bases de datos, modelos y scripts. Puedo crear los invoices que deseas a través de macros en GSheets. Observa mis calificaciones, ellas hablan por si solas. Saludos
€150 EUR în 2 zile
4,9 (237 recenzii)
6,9
6,9
Avatarul utilizatorului
Hi, After reading your project description about developing a Macro to allow PDF Invoice generation, I feel like you have me in mind when creating the project. I have all it takes to deliver. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I will complete a sample part of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! Hope to hear from you soon
€170 EUR în 3 zile
4,9 (53 recenzii)
6,4
6,4
Avatarul utilizatorului
Hi Jaime, I just opened the Spreadsheet and going through with the requirement, I have few question that I would like to discuss, so I can understand you requirement and deliver the 100% output
€155 EUR în 3 zile
4,7 (83 recenzii)
6,4
6,4
Avatarul utilizatorului
- Went through the "Data in Rows tab" - Inovice to PD template and the Macro Inputs - Can have the invoices generated from Data in rows tab and get the information filled in the template and save them as PDF output. - Have done similar PDF generation in Excel and Google(Freelancer projects) My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - 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. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl Sample HighComplex Projects using Macros: (via Freelancer) - Complex Data anlaysis and graphing - Using Surface, Scatter Dynamically setting axis values, legennd colors(Excel 2013 to Excel 2016) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. +...
€160 EUR în 3 zile
4,7 (52 recenzii)
6,0
6,0
Avatarul utilizatorului
Hello, I read your project about converting google docs data to invoice using macro. I can complete this work in less time. Looking forward to work and discuss more about this project with you. Thanks, Shivam Kataria
€160 EUR în 3 zile
5,0 (56 recenzii)
4,8
4,8
Avatarul utilizatorului
are each invoice has one product only?.....................................................................................
€200 EUR în 3 zile
4,9 (7 recenzii)
4,2
4,2
Avatarul utilizatorului
Dear Jaime. Thank you so much for reading proposal. I have great solution for you. We can create a web based solution for the application. There you may add own data and filter search as per need and requirements. Also, we can create custom template for invoice and generate many invoices. Please let me know if this make sense for you. In future if needed we can enhance the system also. Let me know your point of view for the suggestions above. Looking forward for your response. Thanks. Kindest Regards.
€250 EUR în 3 zile
5,0 (3 recenzii)
3,6
3,6
Avatarul utilizatorului
Hi There, I have an expert team of macros ,I will create your macros according to your requirements as well as time frame. Need to discuss over chat PM?
€155 EUR în 3 zile
4,6 (5 recenzii)
3,5
3,5
Avatarul utilizatorului
Hello Project Owner, Greetings of the day! I am interested to work on the Project! Please let me know when to start. Regards, Ashwani
€77 EUR în 1 zi
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Hola Jaime Have you done your task? I saw this project today. If you need some help fell free to contact me. If you need some advises or some fixes you can also contact me)))
€88 EUR în 7 zile
5,0 (1 recenzie)
0,0
0,0

Despre client

Steagul SPAIN
Madrid, Spain
4,9
19
Metoda de plată a fost confirmată
Membru din apr. 19, 2016

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.