I have an Excel document with about 1000 rows of data. Each cell in the second column (column B) contains a UPC number. I want a script or macro or something that will go through my Excel document, use each UPC # to search amazon.com, and get 2 pieces of data from that there and add it in 2 new columns in the same Excel document.
For example, Column B, row 2, contains "634991151023". searching amazon.com brings up this page: http://www.amazon.com/Out-There-Rick-Wakeman/dp/B000093NU0/
from there the main price displayed is "Price: $6.78". I want that added as a new column, column C, in the Excel spreadsheet, e.g. column C row 2 should read "6.78". I also want another piece of information, the sales rank, added in a second new column. in this case it is "Amazon Best Sellers Rank: #168,028". "168028" should be added to column D row 2. the process would repeat with each cell in column B until all cells in column B have been checked.