In Progress

I require a VBA Excel document that creates and saves invoices automatically with one click

I require a VBA Excel document, where I can import order history from Amazon, click generate invoices and it will automatically create and save the invoices into a folder I can specify. It needs to check invoice numbers and if there's multiple, add to the same invoice.

I have attached someones source which you can use as a base if you wish. I need to add a lot more information to the document. I need the invoice to look like the attached, and include:




Unit Price

Price (quantityXUnit Price)

Invoice Subtotal

Shipping Price

Gift Wrap Price

Shipping Discount

Item Discount

Total (Sum)

Buyer Name

Buyer address

Purchase Date

Payment Date

Skills: Excel, Visual Basic, Visual Basic for Apps, Data Processing, Software Architecture

See more: excel vba print to pdf and save, excel macro create pdf, how to program a "save" button in excel vba, vba code to save excel file as pdf, convert excel sheet to pdf using vba, create pdf button in excel, excel vba save as pdf filename from cell, convert excel to pdf and email vba, cut paste vba excel, copying data word document excel document, vba excel action opening workbook, vba excel column label, vba excel delete column, view directory name files cells vba excel, can copy word document paste excel document, vba excel find text word document, excel vba word document property, vba excel search word document, vba excel search line word document, vba excel create xml document

About the Employer:
( 5 reviews ) Aylesbury, United Kingdom

Project ID: #21850253

9 freelancers are bidding on average £154 for this job


Dear Employer, I understand you need a tool to download data and then add the data for same sources. Please message me, I am an expert with over 12 years of experience and will do a perfect job asap. I know I am charg More

£250 GBP in 7 days
(227 Reviews)

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thank you, Asad Khan

£150 GBP in 3 days
(208 Reviews)

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

£150 GBP in 3 days
(401 Reviews)

Greetings! I have reviewed the files and understand your requirements. I can develop an Excel based solution - at the click of a button, user would be prompted to select the csv file from Amazon. Once selected, the fi More

£100 GBP in 3 days
(213 Reviews)

With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked t More

£150 GBP in 3 days
(109 Reviews)

Hi, Would you like to see a quick demo of your project on developing a VBA file that will import from Amazon, create and save invoice into a designated folder completed before you award the project? You can consider it More

£150 GBP in 3 days
(57 Reviews)

Hello, You could use Amazon MWS API which you can code under your macro/VBA environment. Using this method you can query and parse the order list based certain criteria you could set as well. You could see of how it w More

£135 GBP in 7 days
(39 Reviews)

Expert in Data analysis and mathematical modelling. Degree in Mathematics, masters in computational fluid dynamics and expert in Excel and VBA automation development. Relevant Skills and Experience BSc Hons Mathenatic More

£166 GBP in 3 days
(0 Reviews)

Hello! I´ve experience of this kind of work that I enjoy very much. We can discuss more details about your SOW and I can propouse a more precise price. I`ve worked similar projects like that on my experience. Please do More

£135 GBP in 7 days
(0 Reviews)