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

Evner: Excel, Visual Basic, Databehandling, PHP

Se mere: 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

Om arbejdsgiveren:
( 2 bedømmelser ) Hong Kong, Hong Kong

Projekt ID: #21714958

52 freelancere byder i gennemsnit $3535 på dette job


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 and have been featured by the freelancer community (g Flere

$4500 HKD in 3 dage
(739 bedømmelser)

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 Flere

$4000 HKD in 70 dage
(188 bedømmelser)

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 Flere

$4500 HKD in 5 dage
(361 bedømmelser)

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 Flere

$4000 HKD in 5 dage
(230 bedømmelser)

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 in 3 dage
(322 bedømmelser)

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 in 7 dage
(152 bedømmelser)

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 Flere

$3500 HKD in 2 dage
(27 bedømmelser)

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 Flere

$2000 HKD in 60 dage
(33 bedømmelser)

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 Flere

$3000 HKD in 3 dage
(233 bedømmelser)

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 in 3 dage
(339 bedømmelser)

************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 Flere

$10000 HKD in 25 dage
(44 bedømmelser)

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] Flere

$4000 HKD på 1 dag
(119 bedømmelser)

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 Flere

$4000 HKD in 2 dage
(91 bedømmelser)

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 Flere

$3999 HKD in 7 dage
(84 bedømmelser)

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 Flere

$2000 HKD in 2 dage
(145 bedømmelser)

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 Flere

$4000 HKD in 7 dage
(8 bedømmelser)

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 Flere

$2500 HKD in 3 dage
(10 bedømmelser)

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 Flere

$2000 HKD in 3 dage
(27 bedømmelser)

It can be completed as build new app using php and visual basic in excel. My quote is 2000HKD and a week. I can start your project immediately. I can provide full-time communication and work your time-zone. If you give Flere

$2000 HKD in 7 dage
(3 bedømmelser)

Dear Jimmy, I can Build automation by using VBA as I'm expert in VBA and Macro's. I have excellent experience of Excel (VBA/MACROS/FORMULA'S),Data entry, Web Scrapping (Python and Selenium) and Web Research for more Flere

$3200 HKD in 3 dage
(25 bedømmelser)