Hi, nice to be here, hope someone can help. I have a problem with two worksheets, one is products exported from sage, the second is upload file to website of products and all related info. The only common columns between the 2 worksheets is the SKU column and the PRICE column. Because there are numerous extra rows in the sage export file that i dont need and all the product details are in the upload file i need to find a way to compare the SKU column in both worksheets and if the code in the cells exists in both sheets then update the PRICE column in sheet 2, the upload file, from the price column in sheet 1, the sage export.

I really dont know how to go about this, i have tried some compare macros i found on google but i am still getting nowhere.