Kapalı

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 ?

Thanks

Jimmy Ling

Beceriler: Excel, Visual Basic, Veri İşleme, PHP

Daha fazlasını gör: 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

İşveren Hakkında:
( 2 değerlendirme ) Hong Kong, Hong Kong

Proje NO: #21714958

Bu iş için 52 freelancer ortalamada $3535 teklif veriyor

jaylancer43

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 Daha Fazla

$4500 HKD in 3 gün içinde
(739 Değerlendirme)
8.5
wpoppo

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 Daha Fazla

$4000 HKD in 70 gün içinde
(188 Değerlendirme)
8.4
schoudhary1553

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 Daha Fazla

$4500 HKD in 5 gün içinde
(361 Değerlendirme)
8.0
paris2785

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 Daha Fazla

$4000 HKD in 5 gün içinde
(230 Değerlendirme)
7.4
P0L

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 gün içinde
(322 Değerlendirme)
7.3
asadkhan3533

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 gün içinde
(152 Değerlendirme)
6.6
C3guru

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 Daha Fazla

$3500 HKD in 2 gün içinde
(27 Değerlendirme)
6.8
pvsysgroupinc

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 Daha Fazla

$2000 HKD in 60 gün içinde
(33 Değerlendirme)
6.7
elqueabandona

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 Daha Fazla

$3000 HKD in 3 gün içinde
(233 Değerlendirme)
6.9
TonmoyRoy111

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 gün içinde
(339 Değerlendirme)
6.9
erashrafkamal

************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 Daha Fazla

$10000 HKD in 25 gün içinde
(44 Değerlendirme)
6.6
valor312

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] Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% HKD
(119 Değerlendirme)
6.7
MohsanEijaz

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 Daha Fazla

$4000 HKD in 2 gün içinde
(91 Değerlendirme)
6.3
TechnoGuruu

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 Daha Fazla

$3999 HKD in 7 gün içinde
(84 Değerlendirme)
6.0
mtdevil369

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 Daha Fazla

$2000 HKD in 2 gün içinde
(145 Değerlendirme)
6.1
sky19130

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 Daha Fazla

$4000 HKD in 7 gün içinde
(8 Değerlendirme)
5.4
imfarrukh47

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 Daha Fazla

$2500 HKD in 3 gün içinde
(10 Değerlendirme)
4.6
sevillajk01

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 Daha Fazla

$2000 HKD in 3 gün içinde
(27 Değerlendirme)
4.5
Albertbestcoder

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 Daha Fazla

$2000 HKD in 7 gün içinde
(3 Değerlendirme)
4.0
Aishwaryakumari

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 Daha Fazla

$3200 HKD in 3 gün içinde
(25 Değerlendirme)
3.8