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 ...
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?
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?