Help! exporting data from web to excel using excel list

[boater1]

Hoping someone can help write a macro. I have a list of 50,000 parts and need to check the inventory of each part daily. The web address changes based on the part number. So I have an excel list with the web address in column A and part list in column B and i did a concatenate so I now have the 50,000 website addresses as column A on a new excel sheet. I need a macro that goes to the website in spot A1 and then copies the inventory. The inventory pops up as a grid that looks like this :

Warehouse​	Quantity:​
003 - FOND DU LAC,WI​	Over 10​
073 - ATLANTA,GA​	Over 10​
075 - FRESNO,CA​	5​

those are the 3 warehouses that the part can come from and the quantities. I only need the first warehouse quantity.

If all warehouses are out of stock the table is not there and the website states

Item currently is out of stock

I am assuming if the macro doesn't find the table it will just skip which is great.

The site has a few tables.

So the macro needs to go to each different web page (same site just different web address for each part number) it needs to then find the table and copy the data in the top right column and then paste it in to column next to the web address.

Attached is screenshots of the web page with parts available and without parts available. the websites are all password protected.

Thanks!!!

 

[Marc L]

​

As it's insane to do this under Excel the easy way is to ask the people in charge of the website to export the necessary data to a text file like a csv format​

then you will be able to import the text file …​

​

 

[boater1]

​

As it's insane to do this under Excel the easy way is to ask the people in charge of the website to export the necessary data to a text file like a csv format​

then you will be able to import the text file …​

​

they will not provide