Compare Two Spreadsheets and Update Price Based on SKU
$30-250 USD
Paid on delivery
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!
Project ID: #4981365
About the project
Awarded to:
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 freelancers are bidding on average $88 for this job
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 More
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 More
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 More
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 More
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 More
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. More
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 More
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.