Create invoices in Excel 2016 using Pivot Tables and VBA

Dokončeno Zveřejněno před 6 lety K zaplacení v momentě doručení
Dokončeno 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.

Zadávání dat Zpracování dat Excel Visual Basic Visual Basic pro aplikace

Identifikační číslo projektu: #15897577

O projektu

7 nabídek Projekt na dálku Aktivní před 6 lety

Uděleno uživateli:

kolosibalint

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ší

$500 USD za 10 dní
(89 recenzí)
6.1

7 Freelnceři na tento projekt zveřejňují nabídky v průměru $473

jaylancer43

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ší

$500 USD za 2 dní
(537 Recenzí)
8.1
cgullapalli

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ší

$500 USD za 2 dní
(629 Recenzí)
7.7
seaanddream

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ší

$410 USD za 5 dní
(266 Recenzí)
7.5
sandroshubladze

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ší

$470 USD za 4 dní
(159 Recenzí)
6.8
Harun1986

Hello, I will make a automated VBA for you. If you look at my portfolio you will know about my past work. Relevant Skills and Experience I have Excel, VBA, macro skills and I have done too many similar projects in my Další

$340 USD za 10 dní
(178 Recenzí)
6.5
aanvikm

Hello Sir, I am interested in this project. I am an excellent VBA developer and would like to discuss the approach with you. Thanks Aanvik Relevant Skills and Experience VBA Proposed Milestones $588 USD - Default Mil Další

$588 USD za 10 dní
(33 Recenzí)
5.7