The goal of this project is to have a website automatically generate invoices. To do this one must use XLS and PDF file for each unique invoice number is generated.
We will provide a sample of the file and XLS.
Code loops through highlighted cells
For each unique invoice number
In the Invoice Template sheet, copy each across cells from that row as a line item
Work out the totals
Insert the invoice total in to the column “TOTAL”
Save Invoice Template as new xls - Where filename is “[First Name] [Last Name] - [Invoice Number].xls”
Insert the xls filename into the column “Invoice”, linked to the xls file
Generate a unique 16 character string
Save Invoice Template as PDF - Where filename is the unique string
Insert the unique string into the column “PDF”
16 freelancers are bidding on average $66 for this job
Hey..I can create the invoice template and write the supporting VBA Macro that would generate the invoices and print them as PDFs as required. Please see the private message for some details. Thanks and Regards, Shikha
Hello there, I'm a software engineer with 10 years experience in VB6, VBA and .NET. I'm sure I can help you with your task. I'm waiting for detailed project description. Best regards, Adrian
I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I am interested in your project...More in PM.