Đã Đóng

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

Kĩ năng: Excel, Visual Basic, Xử lí dữ liệu, PHP

Xem nhiều hơn: 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

Về Bên Thuê:
( 2 nhận xét ) Hong Kong, Hong Kong

ID dự án: #21714958

52 freelancer đang chào giá trung bình $3535 cho công việc này


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 Thêm

$4500 HKD trong 3 ngày
(739 Nhận xét)

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 Thêm

$4000 HKD trong 70 ngày
(188 Nhận xét)

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 Thêm

$4500 HKD trong 5 ngày
(361 Nhận xét)

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 Thêm

$4000 HKD trong 5 ngày
(230 Nhận xét)

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 trong 3 ngày
(322 Nhận xét)

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 trong 7 ngày
(152 Nhận xét)

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 Thêm

$3500 HKD trong 2 ngày
(27 Nhận xét)

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 Thêm

$2000 HKD trong 60 ngày
(33 Nhận xét)

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 Thêm

$3000 HKD trong 3 ngày
(233 Nhận xét)

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 trong 3 ngày
(339 Nhận xét)

************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 Thêm

$10000 HKD trong 25 ngày
(44 Nhận xét)

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] Thêm

$4000 HKD trong 1 ngày
(119 Nhận xét)

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 Thêm

$4000 HKD trong 2 ngày
(91 Nhận xét)

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 Thêm

$3999 HKD trong 7 ngày
(84 Nhận xét)

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 Thêm

$2000 HKD trong 2 ngày
(145 Nhận xét)

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 Thêm

$4000 HKD trong 7 ngày
(8 Nhận xét)

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 Thêm

$2500 HKD trong 3 ngày
(10 Nhận xét)

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 Thêm

$2000 HKD trong 3 ngày
(27 Nhận xét)

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 Thêm

$2000 HKD trong 7 ngày
(3 Nhận xét)

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 Thêm

$3200 HKD trong 3 ngày
(25 Nhận xét)