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

£20-250 GBP

In Progress

Posted

over 4 years ago

£20-250 GBP

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 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

8 freelancers are bidding on average £153 GBP 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

5.0

(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 charging a bit more than others but you will not regret paying me that looking at my work I promise. Please do check my previous reviews once for your kind consideration!! :) Thanks and Regards, Ash

£250 GBP in 7 days

5.0

(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

5.0

(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 the attached files as well… I can write the macro as requested. Kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.

£150 GBP in 3 days

5.0

(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 professionally done in less than 24 hrs. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I can complete a sample of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.

£150 GBP in 3 days

4.9

(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 file will be processed and invoices generated and saved to folder specified. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based solutions every single day. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi

£100 GBP in 3 days

5.0

(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 don`t take this price as definitive. With VBA it`s posible to apply many interesant capabilities to your project.

£135 GBP in 7 days