Hello everyone, I have a large video game collection in excel that has the value of each game. As time goes on the value changes. I have found a website (pricecharting.com) that updates the game values frequently. My goal is to pull that data and put it into my excel sheet. I have managed to import the proper tables to excel using the "From Web" tool. However, I was wondering if there is an easier way to automate the comparison between my excel sheet and the website? Or should I simply import the table and have VBA code compare and update if necessary? Also, how would I do this?! My VBA code knowledge is minimal. The picture should give a better idea of my goal. Thanks for reading!
Capture.PNG
Bookmarks