In Progress

Excel VBA Invoice Generation

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.

Pseudo code:

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”

Skills: Excel, Visual Basic

See more: excel invoice vba, excel vba invoice template, excel vba invoice, vba invoice excel, invoice vba excel, invoice generation xls, save invoice vba, vba excel generate invoice, vba invoice number, invoice excel vba, invoice excel, vba excel template generation, excel vba invoice number, invoice vba, invoice xls vba, excel invoice generation, excel invoice save pdf vba, vba work, generate unique invoice number vba, save invoice pdf excel, vba invoice, excel vba and, invoice template in excel, excel invoice template , where is invoice?

About the Employer:
( 11 reviews ) Dagenham, United Kingdom

Project ID: #2525413

Awarded to:

FIBIN

Hi, I am an expert in excel and VBA Programming in Excel. I am interested to work for your project .I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% ac More

$50 USD in 2 days
(42 Reviews)
5.3

16 freelancers are bidding on average $66 for this job

koolsidz

Excel Whiz here ;) Please see PMB

$112 USD in 1 day
(103 Reviews)
5.8
mrbrave

Past experience of developing such tool...Please see PMB for a sample.

$75 USD in 2 days
(72 Reviews)
5.4
bouslimi1979

Please check PM. Thanks

$70 USD in 2 days
(32 Reviews)
5.3
shikhamehta

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

$45 USD in 4 days
(47 Reviews)
4.9
adim

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

$70 USD in 2 days
(12 Reviews)
4.3
Pichart

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.

$70 USD in 1 day
(13 Reviews)
3.8
rengrish

Hi I am interested in this project. Please share me complete details. Ready to start immediately

$100 USD in 3 days
(17 Reviews)
3.7
expertatwork

hi Martin we are interested and are very confident of helping you . many a thanks ! -NAVIN

$65 USD in 2 days
(16 Reviews)
3.6
manisankarmani

Belfast, UK based very reliable VBA Excel professional.

$45 USD in 3 days
(11 Reviews)
3.5
vikashgadia

We have 13 years experience in excel vba programming

$40 USD in 0 days
(13 Reviews)
3.5
yadavsatyam2

hii i have 3 years of work experience in VBA programming . I'm ready to do that ..

$55 USD in 3 days
(1 Review)
1.0
techmbapat

Hi, Plz see PMB Regards UJ

$150 USD in 1 day
(0 Reviews)
0.0
altugguven

I have done very similiar projects for work, can complete yours as well.

$30 USD in 2 days
(0 Reviews)
0.0
jasonprabhu

Hi I am new to freelancer and do have excel experience... Please send me the samples to proceed further... Regards Jason

$50 USD in 1 day
(0 Reviews)
0.0
kenkenko

I'm very interested to get the job.

$30 USD in 5 days
(0 Reviews)
0.0