Using Web Tables and VBA Code to Update Values

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

you are pulling data just like stock market data is pulled and/or read. I would say you can't do it the way you want. and the reason is because excel is not a web app. but when you pull from the web via your method or via PQ, excel puts tables in it's memory, via the windows you see when the data is pulled from the web and put inside excel and you see it. and those tables remain there forever, as far as I know. so my guess is, that the easiest way to do this would be this:

- automate pulling data from web and throw to new sheet.
- write code to compare old sheet to new sheet.
- do whatever else you need after that.

those steps will automate the whole process.