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:
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.
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.
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.
19 freelancers are bidding on average $46 for this job
I've done VBA macros for a research project with a local university. The macro can be done in 2 days. Payment can be made after delivery of macro. Check pm for more information.