Compare Two Spreadsheets and Update Price Based on SKU

완료 등록 시간: Sep 30, 2013 착불
완료 착불

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

프로젝트 소개

22 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: Oct 1, 2013

수상자:

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 (0일 이내)
(335건의 리뷰)
7.7

이 일자리에 대한 프리랜서 22 명의 평균 입찰가: $88

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 기타

$35 USD (3일 이내)
(703 리뷰)
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 기타

$50 USD (1일 이내)
(202 리뷰)
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 기타

$65 USD (1일 이내)
(86 리뷰)
6.9
creatorul

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

$263 USD (2일 이내)
(71 리뷰)
7.0
svet63

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

$100 USD (2일 이내)
(80 리뷰)
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 기타

$50 USD (2일 이내)
(59 리뷰)
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 기타

$40 USD (3일 이내)
(69 리뷰)
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 기타

$45 USD (1일 이내)
(62 리뷰)
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' 기타

$45 USD (1일 이내)
(59 리뷰)
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 (1일 이내)
(64 리뷰)
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 (3일 이내)
(24 리뷰)
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 (2일 이내)
(36 리뷰)
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. 기타

$99 USD (0일 이내)
(25 리뷰)
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. 기타

$55 USD (0일 이내)
(21 리뷰)
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 (1일 이내)
(3 리뷰)
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 기타

$45 USD (5일 이내)
(4 리뷰)
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 기타

$231 USD (1일 이내)
(0 리뷰)
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 기타

$45 USD (3일 이내)
(0 리뷰)
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 (5일 이내)
(0 리뷰)
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 (3일 이내)
(0 리뷰)
0.0