Excel Macro For E-Commerce Product Upload

IN PROGRESS
Bids
19
Avg Bid (USD)
$46
Project Budget (USD)
$30 - $250

Project Description:
I need an Excel macro written to automate the product price updating on an e-commerce site.
We currently have 2 spreadsheets.
SPREADSHEET 1 - The first has the product code and the type of product.
SPREADSHEET 2 - The second has the product code and the cost price of the product.

What needs to be done:
step 1.
Sheet 1 needs to be matched against sheet 2 by product code and if the codes match the price from sheet 2 needs to be copied from sheet 1 and the row deleted from sheet 2.

step 2.
Sheet 1 now needs to copy any product codes that do not have a price next to them to another sheet and delete them from sheet 1.

step 3.
Multiply the price in sheet 1 depending on the product type and cost price.
e.g. IF type 1 AND < £30 MULTIPLY by 25%
These multipliers will be in a sheet within the main spreadsheet and the macro needs to run through every product and just apply the muliplier relevant to that product type and price bracket.

If any of this is unclear please PM me for more information.
We will supply spreadsheet examples to work on obviously.

Skills required:
Excel
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.