I have two excel files. Both have one thing in common. the product ID. Once a week i receive from one of the three cooperating wholesale companies a csv stock list. My question:

How can i use one basic list (my website product list including of course the product ID) list to replace stock on the other one???

Thank you in advance for helping me out...