Completed

Excel lookup datas from different worksheet and create invoice packing list and cover note (3 macro need to write)

I need Macro to finish the job automatically .

Open Invoice (template1 ), i will input all data in sheet "INPUT"Row 1-100

The Macro can according to PI number at Cell A1, C1,E1 ..... and lookup data ITEM NO, QTY, DESCRIPTION, UNIT PRICE ........ from "connect [url removed, login to view] Sheet MPRO_INV , [url removed, login to view]

Then output results to [url removed, login to view] Sheet Invoice1 start from ROW25, Invoice2,Invoice3 ....... Packing1 ROW15, Packing2,....... and add Jpg as signature chop at end of the contents .

The most important when amend Quantity and Unit price manually , the total amount must update.

Skills: Excel Macros, Excel VBA

See more: excel vba copy data from another workbook without opening, how to copy data from one sheet to another in excel using macro, macro to copy specific columns from one worksheet to another worksheet, how to copy cells from one sheet to another in excel using vba, macro to copy data from one sheet to another based on criteria, how to transfer data from one excel workbook to another automatically, excel vba copy sheet from one workbook to another, excel macro pull data from another workbook, invoice packing list price list excel, create invoice packing list excel, sample shipping invoice packing list excel, invoice packing list template excel, excel create invoice stock list, template invoice packing list, invoice packing list template, invoice packing list excel template, excel invoice packing list, template invoice packing list excel, invoice packing list excel, invoice packing list sample excel

About the Employer:
( 2 reviews ) Hong Kong, Hong Kong

Project ID: #15662018

Awarded to:

vmadhavan15

I am not a random bidder. I hope I can do this one. Could you please provide the excel sheet that has these information. Please ping me if you are happy with my proposal. Relevant Skills and Experience VBA Propo More

$1500 HKD in 5 days
(8 Reviews)
4.0

16 freelancers are bidding on average $1109 for this job

schoudhary1553

Hello Sir, I have read your project requirement and i can deliver your project with 100% quality . please give me chance to work on your job. Relevant Skills and Experience I have more than 7 years of experience in E More

$1500 HKD in 3 days
(9 Reviews)
4.5
aubrey03

I am an Excel Macro specialist. I am confident that I can create the macro you need because I have a lot of experience in process automation. You may check the feedback in my profile.

$1500 HKD in 3 days
(8 Reviews)
3.4
mikhailkozalski

I am good at this part. Relevant Skills and Experience Excel Macros, Excel VBA Proposed Milestones $2000 HKD - discuss

$2000 HKD in 2 days
(2 Reviews)
2.6
maximwang8661

i just went through your job post. it's very interesting to me. If you hire me, I can start working for you right now. Relevant Skills and Experience excel vba Proposed Milestones $1244 HKD - discuss

$1244 HKD in 3 days
(2 Reviews)
2.0
$1055 HKD in 0 days
(2 Reviews)
1.3
Ainfovision

I have expert team for your Excel Macros, Excel VBA project works, I have 50+ employees in my company they are ready to start works on your projects. For details please contact with us. Relevant Skills and Experien More

$1244 HKD in 3 days
(0 Reviews)
0.0
KristinaB43

I can automate your data and produce required reports with ease. Relevant Skills and Experience I have created complicated excel workbooks .

$1244 HKD in 3 days
(0 Reviews)
0.0
saharelzahar

Hello, I'm ready to start work on it, I have experience more than 10 years in Excel VBA, and I hope to give me the chance to work. thank you. Stay tuned, I'm still working on this proposal.

$280 HKD in 3 days
(0 Reviews)
0.0
Gauutham

I have good experience in writing macros in excel. please give a chance to work in your project. thank you gautham

$1111 HKD in 3 days
(0 Reviews)
0.0
sumesshms

Dear Client, I am a management graduate has 10 years of experience in Sales and business statistics analysis. I am good in summarising and compiling research and survey reports. Few of my works in Excel and Excel More

$1337 HKD in 5 days
(0 Reviews)
0.0
Universalcyber

A proposal has not yet been provided

$555 HKD in 3 days
(0 Reviews)
0.0
caabdul

Hi there, I am Expert in Financial macros and can do this job with excellence. Thanks Relevant Skills and Experience Excel VBA, Finance Proposed Milestones $800 HKD - Milestone

$600 HKD in 5 days
(0 Reviews)
0.0
Prakasha75

I think my profile is suitable for your work. I have been working with such projects for a very long time and im sure i will complete it accurately and within the given time. It would be greatly appreciated if you give More

$444 HKD in 2 days
(0 Reviews)
0.0
Ashutoshtyagi93

Hey I am new here . I have worked in a multi national data analytics firm for 3 years on various tools such as R, Excel, SAS and tableau. I can assure you good quality and in time completion of your report. Please give More

$888 HKD in 3 days
(0 Reviews)
0.0
Shubhamverma9810

A proposal has not yet been provided

$1244 HKD in 3 days
(0 Reviews)
0.0