Project Detail

Excel VBA / Macro - Price and Model Update  

Excel VBA / Macro - Price and Model Update is project number 142675
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: cheungkc

Budget: $30-100

Created: 05/02/2007 at 14:23 EDT

Bid Count: 44

Average Bid:
$ 63

05/07/2007 at 14:23 EDT

Project Creator: ruelarson
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

I have a large list of model numbers and corresponding prices in an Excel worksheet that needs to be updated on a daily basis. I recieve a new excel worksheet each day with updated model numbers and prices.
I need a Macro/VBA tool that will compare the model numbers & prices in the UPDATED excel worksheet with the model numbers & prices in the INVENTORY excel worksheet.

If a price in the Updated worksheet is different from the price in the Inventory worksheet, the price needs to be changed in the Inventory worksheet.

If a model number in the Inventory worksheet does not exists in the Updated worksheet, the cell value (in the v_status column) needs to be set to "Inactive" in the Inventory worksheet.

If a model number in the Inventory worksheet does exist in the Updated worksheet, the cell value (in the v_status column) needs to be set to "Active" in the Inventory worksheet.

If a model number in the Updated worksheet is not in the Inventory worksheet I need some sort of notice (perhaps in a separate worksheet listing the model number).



I've attached a couple of sample file:

1) Update.xls - the Updated worksheet I recieve on a daily basis
2) Inventory.xls - the Inventory worksheet that I need changed to reflect the model numbers and prices in the Updated worksheet.
i) The model number is in the "A" column
(v_products_model)
ii) The price that needs to be updated is in the "M" column
(v_products_price)
iii) The Active/Inactive value is in the "L" column
(v_status)


The ACTUAL Excel worksheets are much bigger (8000+ rows).


Additional files submitted:
Inventory.xls
Updated.xls

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

100

0 days

05-02-2007 17:16 EDT

Looking forward to working with you.

help

 

50

3 days

05-02-2007 23:33 EDT

See private message.

help

 

70

1 day

05-02-2007 22:25 EDT

Hello. I am skilled in VBA, I actually use vba to automate some office works :) please view PMB for mockup.

help

 

100

1 day

05-02-2007 14:35 EDT

Hi, See my PM. Thank you.

help

 

38

1 day

05-06-2007 11:24 EDT

Although I'm an engineer, I'm pretty much familiar with EXCEL and can do it very quickly. See your PMB for example.

help

 

33

1 day

05-04-2007 03:48 EDT

Please see PMB. Thanks

help

 

55

2 days

05-02-2007 22:10 EDT

I will develope the script as soon as selected and escrowed for.

help

 

89.95

1 day

05-02-2007 17:54 EDT

'Model Citizen' Hello my name is Bill.. {smile} I am a VB, VBA, SQL and Excel programming expert, leader and mentor [screenname:wsh2] at www.vbcity.com and www.experts-exchange.com. I have successfully completed several GAF projects, so you can find additional references for me here. I have 20+ years of hands-on Programming and Business Information System experience. I am located in Easton PA USA (halfway between Philadelphia and New York City). American english is my only language. I look forward to assisting you in achieving ALL of your goals in this endeavor. Respectfully, Bill.

help

 

49

2 days

05-02-2007 23:33 EDT

Please see PMB for details. Thank you.

help

 

90

1 day

05-02-2007 22:11 EDT

Hello Please see PMB for details of my bid. Thank you.

help

 

35

0 days

05-03-2007 19:02 EDT

Hello. Please view Private Message for details of the bid. Thank you for your attention!

help

 

100

5 days

05-02-2007 18:10 EDT

I'm good at macros. See PMB.

help

 

60

0 days

05-04-2007 05:08 EDT

please see pm

help

 

30

2 days

05-03-2007 00:48 EDT

Hello We are working with MS-Excel and VBA for the last 7 years. We would do your work at this competitive rate. Give us the job. Get it done, satisfy yourself and then make payment. We wont seek any payment from u until ur job is fully done as per your satisfaction. Hope to hear positively from u. Regards

help

 

95.99

2 days

05-03-2007 01:02 EDT

Eminently doable. Lets do it.

help

 

50

1 day

05-02-2007 18:08 EDT

We did one recently.

help

 

60

1 day

05-03-2007 03:49 EDT

Hi Sir, This is a very simple but interesting project that is well documented. i am very much interested in taking this work and will provide you with an exe which will do everything just by selecting the updated file on day to day basis. Pls. revert me back on the same. Thanks Surajit.

help

 

50

1 day

05-03-2007 03:11 EDT

Please check PMB

help

 

90

2 days

05-03-2007 05:09 EDT

Please see detail on PMB. Regards

help

 

89

1 day

05-02-2007 17:02 EDT

Hi this task can be perfectly done. Regards.

help

 

40

2 days

05-04-2007 16:58 EDT

Kindly check PMB. Thanks...

help

 

100

2 days

05-02-2007 16:37 EDT

Please see PMB

help

 

30

2 days

05-03-2007 06:02 EDT

Hi. I can do this job for you.

help

 

100

1 day

05-02-2007 14:39 EDT

I can deliver this project in a couple of hours. Please see PMB

help

 

100

8 days

05-02-2007 14:43 EDT

Please see my PMB.

help

 

100

2 days

05-02-2007 16:22 EDT

Please read PM

help

 

100

1 day

05-02-2007 18:06 EDT

I have checked the files and worked on your requirement. I will provide you the required macro in just $100 with in no time as I have developed the macro.

help

 

35

3 days

05-02-2007 23:50 EDT

I can do this project perfectly. I have done this type of work earlier. Please check my review.

help

 

30

0 days

05-04-2007 12:39 EDT

Easiest thing in the world

help

 

70

1 day

05-02-2007 18:40 EDT

(No Feedback Yet)

I have many projects in VBA. I can help you with this.

help

 

50

2 days

05-02-2007 23:08 EDT

(No Feedback Yet)

Hi! I can do it right away!

help

 

50

3 days

05-03-2007 00:24 EDT

(No Feedback Yet)

Dear Sir, I will develop a VB or VB.net application for you. The application will take the path of source and destination file and do the updation work for you. Hope this sounds fine for you. Expecting to work on this project for you. Regards, Rajkumar.

help

 

45

2 days

05-03-2007 02:59 EDT

(No Feedback Yet)

Hi! Will do iy with my pleasure. Thank You!

help

 

50

1 day

05-03-2007 04:12 EDT

(No Feedback Yet)

ready to work. I have good Excel/VBA expierence. I am located in Russia.

help

 

70

1 day

05-03-2007 04:49 EDT

(No Feedback Yet)

Good day, Sir I have an experience in VBA, and ready to work on You Best Regards, Maksym

help

 

50

3 days

05-03-2007 06:07 EDT

(No Feedback Yet)

Would be able to complete this project quickly and professionally. Thank you for the opportunity.

help

 

75

5 days

05-03-2007 08:35 EDT

(No Feedback Yet)

I can do this sir,I have already created error check macros,Indexing macros etc., for the bpo industries,I can give you the best results.Thanks

help

 

30

1 day

05-04-2007 00:20 EDT

(No Feedback Yet)

Hi, I can do this project for you.

help

 

30

0 days

05-04-2007 00:35 EDT

(No Feedback Yet)

I can do this , i have >10 years experience in Excel/VBA environment. I will be glad to work with you.

help

dox

 

65

0 days

05-04-2007 04:07 EDT

(No Feedback Yet)

Hello, please see the demo attached in PM. Regards.

help

 

30

1 day

05-04-2007 08:00 EDT

(No Feedback Yet)

I just ready your proyect... contact me and I send to you the files (inventory & updates) with the vba code. Regards!!

help

 

50

1 day

05-05-2007 02:40 EDT

(No Feedback Yet)

I have over eight years of experience with VBA and Excel and I am very interested in working with you on this project. Please see PMB for more details.

help

 

100

15 days

05-06-2007 13:35 EDT

(No Feedback Yet)

i will try to do it

help

 

30

1 day

05-06-2007 13:51 EDT

(No Feedback Yet)

I can complete it,and i hope you give me a chance.

help


    Bid on this Project