Hello,
It is possible that I wanted Macro to check my URL's list in sheet1 to:
1. Scan the website for my keywords list
2. If "0" stock, put text "not available"
3. If product is found, put text "available"
4. The result show in sheet2
5. Repeat until all the URL in the sheet1 are checked
For example:
I have data in sheet1 like this:
<tbody>
</tbody>
I wanted result in sheet2 like this:
<tbody>
</tbody>
Thank You Guys!
It is possible that I wanted Macro to check my URL's list in sheet1 to:
1. Scan the website for my keywords list
2. If "0" stock, put text "not available"
3. If product is found, put text "available"
4. The result show in sheet2
5. Repeat until all the URL in the sheet1 are checked
For example:
I have data in sheet1 like this:
| A | B |
| Keywords | Link |
| acer liquid z630s | http://item.blanja.com/items/search?searchType=Product&keyWords=acer%20liquid%20z630s&sc=0 |
| acer liquid jade primo | http://item.blanja.com/items/search?searchType=Product&keyWords=acer%20liquid%20jade%20primo&sc=0 |
<tbody>
</tbody>
I wanted result in sheet2 like this:
| A | B |
| Keywords | Stock |
| acer liquid z630s | Available |
| acer liquid jade primo | Not Available |
<tbody>
</tbody>
Thank You Guys!
