Manually match products from 2 Spreadsheets and copy/paste data from 1st to 2nd
$30-250 USD
货到付款
I need someone to check and match data from 2 spreadsheets.
The data is about perfumes, so you should have experience and knowledge about perfumes, related brands, models, quantity. Also be able to convert OZ into ML and vice versa because some lines have only one unit type.
Both spreadsheets have similar products but with different name, so they can't be matched with a formula and should be manually matched.
The matching is simply pasting the data from the 1st into the respective line on the 2nd spreadsheet.
You should search each line of the first spreadsheet into the second and copy paste 4 values from the first to the second when you find a match.
EAN, L/M, EDT/EDP, quantity
Ean is in a separate column, (L) and (M) is the gender and it is in the name, EDP/EDT - it is in the name, Quantity in ML - it is in the name -> all in the name of the first spreadsheet.
2400 lines and expected to be matched around at least 500-700. (Many product do not exist in the second spreadsheet, you can filter it by brand first)
I am providing demo data.
* I have just added DEMO of the first spreadsheet - you look here and search these line in the other spreadsheet.
项目ID: #7930129
关于项目
授予:
Hi! While I'm new to Freelancer, I assure you quality work at a fair price. I am a detail-oriented person with excellent project management skills. I would love to work with you on this. I hope you can give m 更多
有83名威客正在参与此工作的竞标,均价$117/小时
Hi, I have read your project description . i am highly interested to do this task .I will show you a sample based on your instructions ,if you are happy with that then i will start the task. Let's discuss and sta 更多
Hi, I have experience in similar type of work. I can search the perfume with ounce/mile liter accurately and update in sheet 2 to make the sheet 2 with complete information. Looking forward to work with you. 更多
Dear Sir/Ma'am, I am a Web research and Data Entry expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from differen 更多
Hello, I have working at Crowdflower since past 3 years as a freelancer and earned a lot of experience about internet research, data entry, form filling, data analysis, excel etc. You can cheek my profile and portfoli 更多
I have thoroughly read your requirements and I have the necessary skills required to perform the project you have outlined here. I Can start the work asap if you provide me this oppurtunity to work for you. I hope you 更多
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportu 更多
Hello Sir, I have see your demo file, for copy paste job in excel i can make VBA macro for you :) Im excel VBA macro and formula Expert :) i can match data from your 2 spreadsheet and copy paste data from 1st and 2 更多
I am interested to do this project. ..............I can start now............................................Lets start
Hi Sir. I am very well acquainted with perfume names and their brands. I shall be able to finish the task in 2 days without failing. Please discuss so we may continue. Regards. Usman
Dear Sir / Ma'am. I saw the uploaded spreadsheets but I am still a bit confused therefore some questions: 1) From which column should I copy the EAN? 2) All the rest of the information is to filled from their na 更多
Hi, Thanks for the opportunity to bid on this project. I have done such data gathering and research in the past for various clients so that I will provide good service. Regards, Jai
Hello sir.. i can match your both spreadsheets with 100% accuracy and Fast..as i have good knowledge about perfumes. consider its done with Guarantee.. lets start work together once again.. thanks