I need a excel automation enable to map cost, price, issue purchase order and invoice

I need a excel automation which has function below:

1. When I input a product item no., it automatic map the product name

2. After I input all the quantity, it automatically make a purchase order

3. After the purchase order is made, it automatically make a invoice

4. The excel allow me to add/change the customer name, address, contact person etc....and also allow me to change the price or cost in the purchase order or invoice manually

5. The excel allow me to increase product item code whenever needed

6. Basically I need you to make a vlookup formula and put these data into the purchase order and invoice automatically

7. I try to make a sample but it does not work but able to show you what I needed.

6. Watch sheet 1 - I only need to input column D (material no = item no)

7. It need to automatically generate data in column E, N, O, P

8. It also need to automatically generate purchase order to supplier according to the material no I input into column D of sheet 1 (The purchase order is something like sheet "purchase order to supplier)

9. When I input supplier name into column H, the Purchase order need to automatically generate purchase order with the correct supplier name, address, tel no., contact person, Purchase order no, product, unit price, total amount and automatically generate "expected completion date" (but allow me to manually input the date if it is not valid under some special condition)

10. The carton marking need to copied from the data sheet "carton marking"

11. How much does it cost ?

12. How long do you to complete it ?


Jimmy Ling

Habilidades: Excel, Visual Basic, Procesamiento de datos, PHP

Ver más: free examples finance function excel vba cost price, cost price excel, company need microsoft excel automation, need excel automation, i have 12 scanned images and each one has 30 rows and 15 column i need you will type the data from images to excel, i have 36 statements that i need entered into excel the maximum number of entries per statement is 86 rows and two columns one c, i need excel data entry, i need excel expert, i need a graphic design for cheap price in minneapolis, i need excel freelancer, i need excel help, i need excel help in agra, I need excel work, i need someone with good web searching skills to look for data for me. it is simple task. my budget is 8$. i will discuss the de, I Need USA wholesalers Price List\ s at-least \ 100\ With UPC Code, Cost, And Description + Each Company\ s Contact Info Compan, A b c d e f g h i j k l m n o p q r s t u v w x y x.......a , I need patterns or shapes cut from wood, hard plastic or metal. Prefer to work with people from US, Canada, Mexico to limit inte, a b c d e f g h i j k l m n o p q r s t u v w x y z, a b c d e f g h i j k l m n o p q r s t u v w x y and z, a b c d e f g h i j k l m n o p q r s t u v w x y z lyrics

Información del empleador:
( 2 comentarios ) Hong Kong, Hong Kong

Nº del proyecto: #21714958

54 freelancers están ofertando el promedio de $3534 para este trabajo


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Más

$4500 HKD en 3 días
(736 comentarios)

Hello, As per need, you need a excel automation enable to map cost, price, issue purchase order and invoice, we have shared our company portfolio please go through it: We have a team of professional Full Stack develo Más

$4000 HKD en 70 días
(188 comentarios)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Más

$4500 HKD en 5 días
(360 comentarios)

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application to automate some processes. I plan to use a combination of f Más

$4000 HKD en 5 días
(230 comentarios)

Hello Jimmy, I’m an Excel/VBA expert and I can complete your project within 3 days. Please check my profile and contact me to discuss further details. Regards.

$3000 HKD en 3 días
(317 comentarios)

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Más

$3000 HKD en 3 días
(233 comentarios)

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

$6000 HKD en 7 días
(150 comentarios)

Dear Sir, As per your requirement we will make your website best and also we will support after work is live as well please allow us to share our services to you hope you will be happy and we will have long term busin Más

$2000 HKD en 60 días
(31 comentarios)

Dear client I understand the requirements you pointed. I can make that all happen in your excel file. It will take max 3 days. Please contact me. Roy

$3000 HKD en 3 días
(333 comentarios)

I read your job description carefully. I can develop an automation script with python. I used python data processing , excel, csv & panda packages in the past automation scripts. These are all related to your job. So Más

$3500 HKD en 2 días
(27 comentarios)

Hi, I have good Microsoft Excel and macro skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know Más

$4000 HKD en 2 días
(91 comentarios)

************PHP EXPERT,,,,,,,,,,,I CAN START NOW*********** IT WILL TAKE 25 TO 30 DAYS IT WILL COST $1250 USD Hello there, Thanks for job posting. I have read the description carefully and give you 100% assistance Más

$10000 HKD en 25 días
(43 comentarios)

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, MS Word, Google Sheet, Access, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management [login to view URL] Más

$4000 HKD en 1 día
(116 comentarios)

Hi, I am a full time freelancer and can work dedicated on this till completion. As per requirements I will develop Automated excel tool for you as per description of the project. I have expertise in Excel, formulas, E Más

$3999 HKD en 7 días
(83 comentarios)

hello ,i am student . i need job .if you give me.i am happy.. i read your details i have no question now. i will complete within 30 hours or [login to view URL] assign me this order. I strongly believe with the skills and know Más

$2000 HKD en 2 días
(143 comentarios)

Hello sir. High-quality & Fast-delivery is promised! As a highly skilled full stack developer and I can help you perfectly. I am very confident with my skills and I'd like to help your business by doing my best. My cli Más

$4000 HKD en 7 días
(8 comentarios)

Dear Sir, My name is Alexander. Thanks for your posting. I'm ready for your project. We can discuss more in detail through our communication. Now I'm waiting for your answer with the mind that I desire you to select m Más

$5000 HKD en 5 días
(22 comentarios)

Hi, I read your project description and as per my understanding, you need automatically generated product invoice and purchase order. I also go through your excel file. Well I am a qualified Microsoft office specialist Más

$2500 HKD en 3 días
(9 comentarios)

Hello! let me help you with your project. I offer high quality and accurate output with a reasonable bid amount. Please do see reviews on my previous projects to better assess my capability and my dealings with my clie Más

$2000 HKD en 3 días
(27 comentarios)

Hello, I can do it within said timelines and cost or may be before that only. I can also provide you sample output first and then if you feel satisfied then only award me the project. I am an automation expert with ov Más

$2000 HKD en 1 día
(3 comentarios)