Compare Two Spreadsheets and Update Price Based on SKU
$30-250 USD
착불
I have two spreadsheets. The common denominator is SKU/Part Number. You will need to compare the two files and update the price in spreadsheet A from spreadsheet B. Some of the SKU's are duplicates with an additional -D(#) appended to the SKU/Part Number (ex: PartNumber-D1 for the first duplicate, PartNumber-D2 for the second duplicate, etc - which will need to reference just the Part number from Sheet 2). Any SKU's that do not have a corresponding match on sheet B should be highlighted in spreadsheet A.
There are 9k+ rows on this particular sheet so this needs to be automated - I will provide a partial list for this project to ensure accuracy (once it's complete I will run the script myself on my own spreadsheets). This is something I will need to use again in the future with other sheets for Manufacturer price updates so I will need to be able to duplicate the process and reuse the script.
Thanks!
프로젝트 ID: #4981365
프로젝트 소개
수상자:
Consider it done. Check my past reviews for your reference. I can implement the solution in couple of hours. Looking forward for your reply.
이 일자리에 대한 프리랜서 22 명의 평균 입찰가: $88
Hello - I am an Expert Techno-Functional Analyst in lots of arenas of IT industry including Excel Macros. I am an Engineering Graduate with an MBA degree. If you see I am among the niche full 5 Star bidder because 기타
Hi, I am an Excel expert and have successfully completed projects similar to your requirement. Shall be providing an Excel macro based solution to automate the task. Let me know and provide sample files for testi 기타
Hi Muscle. I can provide you with the required script in an hour. I have done very similar work before and I know how to get it done again for you. Kindly share the partial sheet and lets begin. Hoping to read back fr 기타
Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experie 기타
Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet co 기타
Expert of excel,have been awarded as MS-EXCEL-MVP for many times. provide your samples so that i can make a perfect solution ASAP.
Hi! I love working on excel. I have done many data manipulation tasks like these. I am offering lowest price to start a long term relationship.
Hello, I can provide you script easily. please give me sample file. i will provide you .net application. that it will compare both excel file. thanks Kalpesh
Similar Project:******https://www.freelancer.com/projects/Data-Entry-Excel/microsoft-excel-edit.html ******** Similar SKU & Part Number related. Good Day!... I'm an Expert in Excel Automation. Having 6+ yrs of Exp. 기타
I can do this now. I master Excel and VBA with about 4 years experience. I am a statistician engineer.
I worked for almost a year at a consumer goods manufacturing company and built an MRP system in excel. Because of that, I am very familiar with dealing with SKUs and their associated data. I eventually rebuilt the MR 기타
I am an experienced IT Automation Manager. i am interested in taking up the project which you are suggesting. Please provide me the details based on which things will become much clearer
God willing, with the experience and skills that I have, I am able to complete the work that you entrusted to me.