Manually match products from 2 Spreadsheets and copy/paste data from 1st to 2nd
$30-250 USD
Paid on delivery
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.
Project ID: #7930129
About the project
Awarded to:
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 More
83 freelancers are bidding on average $117 for this job
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 More
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. More
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 More
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 More
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 More
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 More
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 More
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 More
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