I need a excel automation enable to map cost, price, issue purchase order and invoice
$2000-6000 HKD
Paid on delivery
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 ?
Thanks
Jimmy Ling
Project ID: #21714958
About the project
46 freelancers are bidding on average $3583 for this job
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 More
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.
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
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
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 More
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 More
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 More
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 More
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 More
Hi, Sir, your request is already here! Please, check out my profile Sir, I Also have Great Experience in Accounting, VBA, Excel, Data Entry, Web Search, Data Processing and all type of Office Work. I am very profession More
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 More
Dear, I am interested in participating in your project. I have skill and experience in automating workbooks in MS Excel. Please, share more details. I am available, do not hesitate to contact me. Clarification: • Th More
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 More
Dear client, I have reviewed the Master order template file and also looked at the all the requirements you laid down. I can transform this excel sheet into the one that will fulfill all these requirements. I will use More
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 More
Dear Client! I'm a senior web developer with over 5 years of experience and very strong in this field. If you want to work with me, I am sure I can deliver you a wonderful result as you want. Please send me a message s More
