Forum Discussion
Lowes web querie
I'm trying to set up a web query. I have a table which has two columns to be involved in the web query. In one column I want to be able to place an item number for a product at lowes.com.
In another column I want the price of the item to be automatically taken from the web page and updated at least once a day.
Basically, I want to be able to enter an item number, and have it automatically put the price of the item in the correct column.
When trying to find the price of an item at lowe's, one must go to the search bar enter the product number and usually the user will be directed to the item page where they clearly see the items price.
I'm trying to set up a construction estimate sheet with the prices of products automatically being pulled from Lowes when one enters the item number.
In another column I want the price of the item to be automatically taken from the web page and updated at least once a day.
Basically, I want to be able to enter an item number, and have it automatically put the price of the item in the correct column.
When trying to find the price of an item at lowe's, one must go to the search bar enter the product number and usually the user will be directed to the item page where they clearly see the items price.
I'm trying to set up a construction estimate sheet with the prices of products automatically being pulled from Lowes when one enters the item number.
6 Replies
- The way you put it is more confusing? try take your time and write the problem one step at a time
- 1. I have a table with two columns.
2. In the first column, I'd like to put an item number.
3. In the second column, I'd like a web query to enter the item number from the first column into the search bar at Lowes, and then snatch the price for that item from the page it's redirected to after the search.
Result: one column with an item number, another column with a price for the item, kept up to date.
Is this possible with Excel?
Is there a workaround to make it possible?- Do you have a sample data?
