Hey guys! First time posting here, hoping to hear some ideas from bright people such as yourselves
. I myself am pretty much a rookie when it comes to VBA's but I have played around with macros quite a bit. Anyways I work for a card store and a lot of our sales come from online. We like to keep our card's prices as updated as possible, this involves going to Amazon, looking each card's price up individually and updating it accordingly. This takes quite a lot of time and would be much easier if we could simply look at one spread sheet that contains all the updated prices. So I figured I should I'd play around in excel to see if I could come up with a way to accomplish this.
I have a macro set up that reads the data from the web into excel. Here is an example of a web page I pull data from:Amazon.com: Buying Choices: Pokemon Black & White Single Card Pikachu #115 Secret Rare
The problem is that a lot of junk comes along with the actual numbers I need. I have a spreadsheet to illustrate this. Basically I need to find a VBA code that deletes every row that does NOT have currency OR the term "total ratings" in it.
I've posted this on a few forums and received no help yet. If you want to download the sample spreadhseet you can find it on my post here: Cleaning up Data Scraped From the Web by Deleting Certain Rows
On my spreadsheet "sheet 1" is what the data looks like right after I pull it off the web and "sheet 2" is the end result that I am trying to achieve.
One of the things that make this problem very difficult for me is the fact that the data is going to change every time I pull it off the web because card prices are constantly changing and companies are listing cards cheaper than others at different times. It is not as simple as recording a macro that deletes rows:3-6 ,10-13 etc.
I have a macro set up that reads the data from the web into excel. Here is an example of a web page I pull data from:Amazon.com: Buying Choices: Pokemon Black & White Single Card Pikachu #115 Secret Rare
The problem is that a lot of junk comes along with the actual numbers I need. I have a spreadsheet to illustrate this. Basically I need to find a VBA code that deletes every row that does NOT have currency OR the term "total ratings" in it.
I've posted this on a few forums and received no help yet. If you want to download the sample spreadhseet you can find it on my post here: Cleaning up Data Scraped From the Web by Deleting Certain Rows
On my spreadsheet "sheet 1" is what the data looks like right after I pull it off the web and "sheet 2" is the end result that I am trying to achieve.
One of the things that make this problem very difficult for me is the fact that the data is going to change every time I pull it off the web because card prices are constantly changing and companies are listing cards cheaper than others at different times. It is not as simple as recording a macro that deletes rows:3-6 ,10-13 etc.
