Hello Everyone,
I am in need of some help. i am developing a sheet to make my life easier looking up pricing from sheet to sheet. I have copied our supplier price list into my sheet on "sheet 2" and on "sheet 1" i have all my products that i require pricing for on "sheet 1" i then need a macro to look into "sheet 2" and match the first 5 digits of the product code and then put the price from the cell to the right over to "sheet 1" beside the correct product code. there will be alot more products in "sheet 2" so it only needs to update or move pricing for products i need.
Any help would be great,
Regards
Anthony
Bookmarks