Find Jobs
Hire Freelancers

Excel macro to manage proforma invoices and records .pdf..

$10-30 CAD

Closed
Posted 5 months ago

$10-30 CAD

Paid on delivery
I am looking for a freelancer who can create an Excel macro to manage proforma invoices and generate .pdf records. We are generating proforma invoices on a daily basis for DHL shipments and need the workflow to be more efficient. Basically we need the operator to select : 1/ Envelope or Package 2/ Destination (among 6 addresses) 3/ Input the number of samples inside the shipment 4/ Input the airwaybill number Based on the above the invoice should be generated with : - current date - unique invoice number (incremental number based on the year e.g 17.11.2023-01) - correct destination address - number and type of sample with corresponding value Template: - The client will provide the template for the proforma invoices. .pdf records: - The macro should automatically generate .pdf records of the invoices based on the invoice number and print it upon validation. Complexity: - The Excel macro should have an intermediate level of complexity, including data analysis functions. Ideal skills and experience: - Proficiency in Excel VBA programming - Experience in creating macros for invoice management - Strong understanding of data analysis functions in Excel Note: we will pay 10-15 Dollars only
Project ID: 37453727

About the project

19 proposals
Remote project
Active 4 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average $31 CAD for this job
User Avatar
""""""""""""""""""""""""""""""""ADVANCE EXCEL MACRO EXPERT"""""""""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 300+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$36 CAD in 1 day
4.9 (272 reviews)
7.3
7.3
User Avatar
Hi there, I can create Excel macro to manage proforma invoices and records and generate into pdf based on your requirements. I am a proficient expert with 10 years of experience in Excel VBA, MS Access, Power BI, and Tableau. My expertise encompasses the creation of automation tools, complex formulas, macros, and the development of insightful dashboards in Power BI and Tableau. I am open to discussions and negotiations regarding pricing. Please feel free to contact me for further details and collaboration opportunities. Best regards, Ravinder Kumar
$50 CAD in 2 days
4.9 (160 reviews)
6.1
6.1
User Avatar
Hello, I am a proficient Excel VBA programmer with extensive experience in creating macros for efficient invoice management. I understand the need for an intermediate-level complexity solution to streamline your proforma invoicing process for DHL shipments. By incorporating user-friendly prompts for selecting shipment details, I will design an Excel macro that dynamically generates invoices with the required information, including the current date, unique incremental invoice number, destination address, and sample details. The macro will seamlessly convert these invoices into .pdf records, optimizing the workflow for increased efficiency. I am confident in delivering a tailored solution that aligns with your specific requirements. Considering your budget constraints, I am prepared to undertake this project for 10-15 Dollars, ensuring a cost-effective and impactful solution to enhance your daily invoicing operations. Please consider my proposal for this project. Regards, Zafar
$15 CAD in 7 days
4.9 (42 reviews)
4.6
4.6
User Avatar
Hello, I'm Basanta and I'm excited to hear that you're looking for a freelancer to create an Excel macro to manage proforma invoices and generate .pdf records. With over 12+ years of experience in different domains, I am confident that I have the skills necessary to help you with this project. My skills include advanced formula editing in Excel, VBA/Macro programming and writing in Ms Access, Work Flow Management tools in Power BI and Power Query, MySQL knowledge as well as option strategies on the stock market. Additionally, I have extensive experience in data analysis functions in Excel as well as web scaping and tableau finance & accounting tasks.
$20 CAD in 1 day
4.9 (55 reviews)
4.2
4.2
User Avatar
Hello, We have been working on excel, vba, macros, finance for more than 9 years. We have more than 8 years of experience doing data based projects. I believe this is something I can for sure :) You may check the projects I have already completed here: https://www.freelancer.com/projects/excel/Excel-VBA-Data-Entry-Analysis-32285292/reviews https://www.freelancer.com/projects/excel/Data-Analytics-Project-30073140/details https://www.freelancer.com/projects/data-mining/DATA-MINING-ANALYSIS-USING-NEURAL/reviews https://www.freelancer.com/projects/excel/Hire-Excel-Expert-15193739 I would love to discuss the project further :). Best, Hem
$21 CAD in 2 days
5.0 (21 reviews)
4.3
4.3
User Avatar
my work is very serious and dynamic, I am punctual and fast I can very well help you in this job I have a lot of experience in invoices ;the data entry ,world excel,pdf, I would like work with you thank you.
$20 CAD in 7 days
5.0 (6 reviews)
2.2
2.2
User Avatar
Hello there! My name is kavit and I am a professional freelancer with 6 years of data entry experience. I understand you are looking for someone to create an Excel macro to manage proforma invoices and generate .pdf records. We are generating proforma invoices on a daily basis for DHL shipments and need the workflow to be more efficient. With my skillset, I am confident that I can provide the solution you are looking for. My proficiency in Excel VBA programming makes me the perfect candidate for this project due to its complex nature. Additionally, my experience in creating macros for invoice management and knowledge of data analysis functions in Excel make me an ideal fit for this job. I believe that my skillset makes me the perfect fit for this project and would love to discuss further if given the chance. Please feel free to contact me if you have any questions or would like more information about me or my services. Thank you for considering me!
$10 CAD in 1 day
5.0 (13 reviews)
0.0
0.0
User Avatar
Hi' I read your note so I am perfect for your job. I am capable for this work. I am a student. I have been doing this work for the last two years. If you give me this work, I will not let you down. As you said you need a freelancer who expert in it. I am free now so you can give me this work. I am an expert in data entry, data processing and MS Excel. So you can give me this work without any hesitation. Thank you so much!
$20 CAD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, my name is Asad and I am a dedicated data maestro with over a decade of freelancing experience. I have worked on many projects related to Excel macros and .pdf records, so I understand the importance of your project. I specialize in creating Excel macros that can manage proforma invoices and generate .pdf records. With my skillset, I am confident that I can build an Excel macro that can meet all your needs for the Excel macro to manage proforma invoices and generate .pdf records. I would be delighted to work with you to create an efficient workflow for generating proforma invoices for DHL shipments that will meet your needs more efficiently than current methods allow. Please let me know if you would like me to provide any more information or discuss further how we can make this project successful together.
$10 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I AM THE ONLY ONE TO DO THE WORK AS MY WORK EXPERIENCE IN THE COLLEGE IS EXCELLENT OF COMPLETING THE WORL BEFORE TIME . I HAVE TRUE BELEIVE IN MY HARD WORK ,DIGNITY TOWARDS MY WORK AS WELL AS HAVE A TRUE BELIEF IN THE SYSTEM TOO .
$20 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Tintswalo, a professional freelancer with Report Writing skills and administrative skills. I have experience in creating macros for invoice management and strong understanding of data analysis functions in Excel. I am confident that my skillset make me the best fit for this project. My experience in related fields makes me an ideal candidate for the job. Moreover, I have been working under Safety and Security unit for the past 18 years as an Assistant Director. I'm sure my expertise in Excel macro development will prove invaluable in making sure that your invoices are accurate and timely delivered. Please feel free to reach out if you have any questions or would like me to provide more information about myself or my services. Thank you for considering me for this project!
$20 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am confident that I can help you create an Excel macro to manage proforma invoices and generate .pdf records for your project. With my extensive experience in data entry and data processing, as well as in Excel VBA programming and creating macros for invoice management, I am well-equipped to tackle this task. My skillset enables me to analyze data analysis functions in Excel to create an intermediate level of complexity in the macro. This makes sure that the flow is efficient enough to generate correct invoices with the current date, unique invoice numbers (incrementally based on the year), correct destination addresses and number of samples with corresponding values. Additionally, I make use of templates provided by the client so that the records are generated automatically at validation without requiring user interaction. I believe I am the best fit for this project due to my dedication to delivering high quality solutions while maintaining security and performance standards at all times. Additionally, I am up-to-date with industry trends and technologies so that I can provide innovative and cutting-edge solutions to clients.
$20 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Speciality: I am a Professional Data Entry Expert. Job Skilled: I will do data entry, copy paste, web research, excel data entr, pdf to excel JOB DESCRIPTION : I am skilled freelance professional from Bangladesh with honars degree in Computer Application. I have Data Entry Services 3+Years of experience in data entry, Email Signature,copy paste,pdf to excel services for businesses across various industries with cost effective solutions. What i work on: Data entry from PDF files to excel Data entry image files to excel Data entry from word to excel I do design canva templates I do invoice
$20 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm eager to contribute to your Proforma Invoicing project. With expertise in data management and Excel, I can streamline the workflow for DHL shipments. My proposed Excel macro ensures accurate, template-compliant invoices with a user-friendly interface. My skills in Excel VBA programming and invoice management make me an ideal candidate. I'm ready to provide a tailored sample to showcase my capabilities. I'm keen to discuss your project further. Let's connect and explore how I can enhance your invoicing process. Best regards, Sachin
$16 CAD in 3 days
5.0 (1 review)
0.2
0.2
User Avatar
I am writing to express my keen interest in the General Virtual Assistant /Freelancer . With my [09123735572] I am confident that I possess the skills to provide your organization with the comprehensive administrative support it needs to thrive.
$20 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Proficient in Excel VBA programming and experienced in creating macros for invoice management. Strong understanding of data analysis functions in Excel. Can develop an intermediate-level complexity Excel macro to efficiently manage proforma invoices and generate .pdf records. Will follow the provided template for proforma invoices and automatically generate .pdf records based on the invoice number. Available to start working on the project immediately and can deliver a high-quality macro within a reasonable timeframe. Understand your budget constraints and can provide a cost-effective solution within the specified budget of 10-15 USD.
$10 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert in VBA excel and data analysis. I have extensive experience in creating macros and forms for data analysis and user interaction. I'm sure I can help with your project.
$20 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have a good experience with excel vba and I can generate the needed pdf file (using a simple button on excel) withon few hours I may need more informations like how data are saved each time and the period of generated pdf needed Regards
$40 CAD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BANGLADESH
Fulbari, Bangladesh
0.0
0
Member since Jun 16, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.