Excel VBA / Macro - Price and Model Update

IN PROGRESS
Bids
44
Avg Bid (USD)
$63
Project Budget (USD)
$30 - $100

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).

Skills required:
Data Processing, Script Install, Visual Basic
Additional Files: Inventory.xls Updated.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.