VB Project - Take Pull List of Items and Generate Invoice in Excel

$10-30 USD

Completed

Posted

about 7 years ago

$10-30 USD

Paid on delivery

On the Excel workbook attached, I enter quantity requests in Column H for a customer. After the pull quantities are completed, I can Execute the pick list, which will deduct all the quantities from the Column F. However now, I would like a separate button called "Execute Invoice" which will perform the following: For all non-blank quantities in field[Order], populate an excel template with the following fields: UPC, Description, Order, Price, TOTAL price. The excel template, which will be used as the official invoice, will include a company logo, Billing/Shipping address, etc.

Data Entry

Excel

Visual Basic

Project ID: 13629927

About the project

9 proposals

Remote project

Active 7 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

Awarded to:

@naseefo

Hi there! I have seen the two sheets in your MS Excel sheet which contains the information regarding media, games and books with all the required field required for your invoice. I have expertise in advanced techniques in MS Excel wtih VBA to generate invoice. Kindly get in touch via chat if you wish to discuss in more details. Thank you. Warm regards, Naseef Ummer

$25 USD in 1 day

5.0

(7 reviews)

3.5

9 freelancers are bidding on average $26 USD for this job

@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 for further details. Thanks and regards Roy

$30 USD in 1 day

4.9

(263 reviews)

6.5

@ranganathp

FREELANCER RECOMMENDED ------------------------------------------------------ Can help... I am an Expert... Lets Start! Please start a Discussion with me and we can get started from there... Please check the past projects I have handled and check my reviews for what employers have to say about my work... Can start right now...

$25 USD in 1 day

5.0

(4 reviews)

4.4

@RMaheshwari26

i am working as a business analyst in a startup and my work includes making Excel models and data crunching to find insights and patterns from data. my proficiency in excel and tools like python, combined with my dedication to complete work within timeliness makes me a ideal match for this work.

$20 USD in 1 day