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

In Progress Posted 4 years ago Paid on delivery
In Progress Paid on delivery

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

Excel Visual Basic Visual Basic for Apps Data Processing Software Architecture

Project ID: #21850253

About the project

8 proposals Remote project Active 4 years ago

8 freelancers are bidding on average £153 for this job

fixitconsultech

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
(815 Reviews)
8.5
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 More

£250 GBP in 7 days
(342 Reviews)
8.5
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 days
(509 Reviews)
7.8
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 More

£150 GBP in 3 days
(182 Reviews)
7.7
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 More

£150 GBP in 3 days
(83 Reviews)
7.1
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 More

£100 GBP in 3 days
(261 Reviews)
7.2
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 More

£135 GBP in 7 days
(0 Reviews)
0.0