Compare Two Spreadsheets and Update Price Based on SKU

Completed Posted Sep 30, 2013 Paid on delivery
Completed 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!

Excel Visual Basic

Project ID: #4981365

About the project

22 proposals Remote project Active Oct 1, 2013

Awarded to:

Teloquence

Consider it done. Check my past reviews for your reference. I can implement the solution in couple of hours. Looking forward for your reply.

$50 USD in 0 days
(335 Reviews)
7.7

22 freelancers are bidding on average $88 for this job

jaylancer43

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

$35 USD in 3 days
(703 Reviews)
8.4
deepbluetech

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

$50 USD in 1 day
(202 Reviews)
7.4
maverick44000

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

$65 USD in 1 day
(86 Reviews)
6.9
creatorul

Hello, Do you want this tool for Windows or MAC? Regards, Daniel

$263 USD in 2 days
(71 Reviews)
7.0
svet63

VBA developer since 1997. Can do. Regards, Svet.

$100 USD in 2 days
(80 Reviews)
6.7
sswijaya

Hi, I would like to help you with your project. I can do this task using excel VBA. My idea is to create the macro in 1 master file and this can be used for any files. The macro will ask for the name of spreadsheets More

$50 USD in 2 days
(59 Reviews)
6.4
SiroosJafary

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

$40 USD in 3 days
(69 Reviews)
6.0
nagybatonyi

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

$45 USD in 1 day
(62 Reviews)
5.7
elMancha

Hello there. I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I' More

$45 USD in 1 day
(59 Reviews)
5.4
northwolves

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.

$45 USD in 1 day
(64 Reviews)
5.3
satsin7

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.

$30 USD in 3 days
(24 Reviews)
5.5
kalpesh2804

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

$34 USD in 2 days
(36 Reviews)
5.5
proauthor

Hi, Ready to start your work. Eagerly awaiting for your positive reply. I can compare the two sheet programmatically and update you. I am ready to start working on your project. Looking forward to working with you. More

$99 USD in 0 days
(25 Reviews)
4.6
Edison1983

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

$55 USD in 0 days
(21 Reviews)
4.4
inoussakabore

I can do this now. I master Excel and VBA with about 4 years experience. I am a statistician engineer.

$55 USD in 1 day
(3 Reviews)
3.3
Snap2Art

Assuming both files are Excel (and not version > Office 7) As a former IT Lecturer who presented, amongst others, Advance Excel to post school varsity students, I have only received 5 star ratings from my Excel empl More

$45 USD in 5 days
(4 Reviews)
2.4
bigdognec

Hello, Are you open to a Java or a web based solution for this? To be able to reuse the code, the structure of the sheets should be know or a configuration to set the field name to map should be provided. I h More

$231 USD in 1 day
(0 Reviews)
3.3
flanaganca

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

$45 USD in 3 days
(0 Reviews)
0.0
sunilvedula

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

$222 USD in 5 days
(0 Reviews)
0.0
malikha1969

God willing, with the experience and skills that I have, I am able to complete the work that you entrusted to me.

$175 USD in 3 days
(0 Reviews)
0.0