Manually match products from 2 Spreadsheets and copy/paste data from 1st to 2nd
$30-250 USD
Teslim sırasında ödenir
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.
Proje NO: #7930129
Proje hakkında
Seçilen:
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 Daha Fazla
Bu iş için 83 freelancer ortalamada $117 teklif veriyor
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 Daha Fazla
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. Daha Fazla
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 Daha Fazla
Sir, TEAM HERE to work and complete in 3-5 days at the best :-) Let's discuss more and finalize the project. We have our own workplace with 7+ working PCs and laptops, with ~10mbps internet connections. And we neve Daha Fazla
Hello sir, Consider it as done .. I completely understood about the requirements. I checked your attached file and surely i can do this .. Let me know if you want sample ?? Able to do it within 48 hours, able to m Daha Fazla
Hi I have read your job description ... I have expertise in this field. I did several job perfectly like this one . I can fulfill your requirement . High quality work goes cheap . I assure 100% satis Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
Hi, you have two spreadsheets with similar products but with different names. And the products should be matched from the first spreadsheet to second spreadsheet. I will do it manually with much care to make the proj Daha Fazla
Hello, have an excellent knowledge of perfumes, I am skilled in MS Excel and have a great eye for detail. I always complete my projects in full and gain five star reviews from each of my clients. I am reliable, I wi Daha Fazla
Hi sir, Iam expert in excel handling and product uplaod into magneto, ecommerce, woocommerce, prestashop and joomla sites. I have done 31 projects regarding the same. Ping me i will map the excel in a correct way in Daha Fazla
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 Daha Fazla
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
