Create invoices in Excel 2016 using Pivot Tables and VBA
$250-750 USD
K zaplacení v momentě doručení
We have an Excel Sheet with details of work to be invoiced each month.
We have used Pivot Tables and VBA to create the Invoice.
Additional VBA is required to do the following.
1. Add the header row of the pivot table to each page of the Invoice.
2. Increment the Invoice Number by 1 each time an invoice is printed.
3. Add the customer’s name & Address to the top of each Invoice
4. Repeat saving each Invoice as a PDF (named Company & Invoice No.) until all invoices have been generated and saved.
5. Save each invoice printed in one line on a new worksheet for keeping a record. The line will contain. Inv. No., Date, Company, net cost excluding VAT & Total Cost, Incl VAT.
6. Some additional formatting may be required to ensure that the invoice looks professional
The sample Invoice is uploaded and the new VBA can be added to it if you wish.
Identifikační číslo projektu: #15897577
O projektu
Uděleno uživateli:
Hi, Based on the slicers it seems you create one invoice a month for each client. I can't see company data in the file. Do you have a company sheet/table in the actual file? Relevant Skills and Experience I think nam Další
7 Freelnceři na tento projekt zveřejňují nabídky v průměru $473
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En Další
HI, I am good at Excel and vba. I have reviewed the details of the project. Happy to update the code as required. I would like to discuss further in the chat. -Chandra Relevant Skills and Experience Excel vba, Advan Další
Hi, my name is Sevinc. I read your "Create invoices in Excel 2016 using Pivot Tables and VBA" project descriptions carefully before bidding. I checked the attached template as well... Relevant Skills and Experience I Další
Hello, I am Experienced VBA Developer with skills of financial auditor So I can perfectly complete all above stated tasks If interested, please let me know Thanks Relevant Skills and Experience Excel Expert and VBA De Další