I gang

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:

SKU

Description

Quantity

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

Evner: Excel, Visual Basic, Visual Basic for Apps, Databehandling, Software Arkitektur

Se mere: 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

Om arbejdsgiveren:
( 5 bedømmelser ) Aylesbury, United Kingdom

Projekt ID: #21850253

11 freelancere byder i gennemsnit £156 på dette job

asin1987

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 Flere

£250 GBP in 7 dage
(208 bedømmelser)
7.7
TonmoyRoy111

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 dage
(339 bedømmelser)
6.9
ksriniravi

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 Flere

£100 GBP in 3 dage
(193 bedømmelser)
6.9
asadkhan3533

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 dage
(152 bedømmelser)
6.6
dvcontact

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 Flere

£150 GBP in 3 dage
(50 bedømmelser)
6.4
sloker18

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 Flere

£150 GBP in 3 dage
(93 bedømmelser)
6.0
khanicha

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 Flere

£135 GBP in 7 dage
(34 bedømmelser)
6.1
polite90

I have rich experience with excel and vba macro. I have done many excel macro with vba. I can do it perfectly. hope to work with you.

£200 GBP in 2 dage
(4 bedømmelser)
4.2
topexpert713

Hi, Nice to meet you! I have read your requirements carefully and I am very interested in your project. I am confident of this project as I'm a professional Python expert with over 5 years of experience. It seems to b Flere

£135 GBP in 7 dage
(7 bedømmelser)
3.7
adam31415

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 Flere

£166 GBP in 3 dage
(0 bedømmelser)
0.0
jecas

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 Flere

£135 GBP in 7 dage
(0 bedømmelser)
0.0