Compare and Update Spreadsheet

$30-250 CAD

Cancelled

Posted

about 10 years ago

$30-250 CAD

Paid on delivery

I have a web store (I'm using NOP Commerce) that has 9000+ items and I need to update the prices. I can download the items to an excel spreadsheet and my supplier has provided me with and updated price list in Excel format... so somehow I need to run one or more macros/scripts to match up the two spreadsheets with the following results: 1) Match up the manufacturer numbers and on the ones that match up, replace both the cost and retail prices on the web store spreadsheet with the new prices provided on my suppliers spreadsheet. 2) Remove any items that are listed on the web store spreadsheet but do not appear on the supplier spreadsheet (AKA, the items that have now been discontinued by my supplier) 3) Generate a separate spreadsheet containing the items that are listed on the supplier spreadsheet but do not appear on the web store spreadsheet.(AKA, new items that need to be added to the web store) Thanks :) Tamara

Excel

Project ID: 5811705

About the project

22 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

22 freelancers are bidding on average $119 CAD for this job

@Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$80 CAD in 0 day

4.9

(198 reviews)

6.8

@priyal1997

Dear Sir As a top rated excel expert,I'm happy to help you on this and I can complete this within few hours with 100% accuracy. I look forward to hearing from you soon. Best regards Priyal

$90 CAD in 1 day

5.0

(90 reviews)

6.1

@maverick44000

HI Thorpe. I have read the project description and I can write a VBA script in Excel for you that would compare the Excel sheets and create a revised list for you just as you desire. Kindly discuss. Regards. Usman.

$130 CAD in 2 days

5.0

(36 reviews)

5.9

@dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.

$100 CAD in 3 days

5.0

(33 reviews)

5.1

@faialeem

Hi I am offering my services as per your project description, I have done similar with my previous employer, I have a software name compare Excel Sheet, in this i put both sheets and third sheet is generated with yellow highlights , which shows the items ( stock and prices), which are not in Web store sheet but showing in vendor sheet. My projects links are http://www.freelancer.com/projects/Web-Site-Updates.html http://www.freelancer.com/projects/Data-Cut-Paste.html http://www.freelancer.com/projects/Web-Site-Image-Text-Modify.html http://www.freelancer.com/projects/Web-Search/Web-Images.html I am here ready for any sample submission or trial work, hope you will consider my proposal Thanks Faisal

$100 CAD in 3 days

4.9

(14 reviews)

4.0

@rohitpithisaria

Hi... I am an excel expert. I have completed more than 100 project in excel. I have done this type of work before and can submit it with 100% accuracy. Hope to hear from you soon. Best Regards, Rohit Pithisaria

$83 CAD in 3 days

4.8

(9 reviews)

3.6

@adityasl

A proposal has not yet been provided

$30 CAD in 1 day

5.0

(16 reviews)

3.5

@mirniyazuddin92

$147 CAD in 3 days

4.8

(11 reviews)

2.3

@jawadakr

Hi Tamara I am interesting in doing this job. sound like something different than my normal doing work. looking forward to work with you. thank you jawad

$315 CAD in 15 days

5.0

(1 review)

2.2

@mobiletechMN

I can do this. I live in the Midwest, obviously fluent in English and I get it.... Here's my take on what your looking for: Develop an excel app where you can simply click a button. You will be prompted to choose original file and new pricing file. VBA will work within excel and perform the following: 1. Perform a Lookup with data from new pricing and replace pricing data in old file. 2. Delete rows that have not been updated/or part of new price file. 3. Allow you to save a new version of the old file. I just finished a decent sized project with victorcab. Please see profile for more info. I completely underbid his project but was looking for good reviews as I am new to freelancer. The project is finished with great results and feedback. I'm doing the same here for the same reason. This seems fairly straight forward. Lets roll. Seriously, no B.S.

$45 CAD in 3 days

5.0

(1 review)

1.9

@mahisha123

HI I’ve gone through your requirement, I am very confidence that I can do this task well. I do have expertise in the specified area. I am very much interested to work with you on this project. Please respond me so that we can discuss it in-detail. Look forward for your response and seeking a chance to work with you. Thanks Mahi

$222 CAD in 3 days

4.9

(3 reviews)

1.9

@jacobJordan

Hello. Could u send them now ?

$50 CAD in 2 days

5.0

(2 reviews)

1.2

@sawangupta

Hi, Do you require this to be done everytime you receive a new excel sheet from supplier ? Or is this one time job. I can help you with creating macro which will update prices. Thanks! Sawan

$166 CAD in 3 days

5.0

(1 review)

0.0

@rkhyd

I can finish the project right now within next hour and deliver it to you. Pay only after you verify the quality of the work.

$100 CAD in 1 day

0.0

(0 reviews)

0.0

@cutenasrin

Hello, I have read your job description and understand. I'll try my best to give you better service. You can give me more details instruction and I'm able to follow carefully and get the job done. Also able to work first and accurately with communicate daily. You can depend on me for accuracy work. I have a range of qualifications as equivalents you may require: Administrative support and management with high quality service, - Have extensive knowledge and ability with Strong skills in using most of Administrative utilities. - MS Office applications include PPT, Excel, and Word. - Adobe Creative suit include Photoshop cs6, Illustrator cs6 - WordPress, megento, ebay, amazon, YellowPage, LinkedIn.. - Performing data inquiries and searches, Modifying, updating, and correcting data. - Have a team. Team size 10 Persons. You can add me on your Skype. Will wait for your reply Your sincerely Cute Nasrin

$200 CAD in 3 days

0.0

(0 reviews)

0.0

@amandacox

I can configure a formula for excel that will allow you to copy and paste or even merge the two documents for farther usage. Highly proficient in Excel (over 20 years) and already have it ready to run for your project.

$155 CAD in 2 days

0.0

(0 reviews)

0.0

@sbshatl

Ready to start Sir,Ready to start Sir,Ready to start Sir,Ready to start Sir,Ready to start Sir,Ready to start Sir,Ready to start Sir,Ready to start Sir,Ready to start Sir,Ready to start Sir,

$155 CAD in 3 days

0.0

(0 reviews)

0.0

@apowless83

I work on these types of projects daily, I do not have anything I can upload to you but I am very familiar with macros and formulas. What you are asking for sounds simple and I can complete it for you under the cost of the other bidders. Your project will be the only one I work on until completion. Thank you, Andrea McKinley

$83 CAD in 3 days