look up data based on UPC and add data to Excel document
$30-250 USD
Closed
Posted about 12 years ago
$30-250 USD
Paid on delivery
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 [login to view URL], 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 [login to view URL] brings up this page: [login to view URL]
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.
Dear sir
Have a nice day,
I am seriously want to get the task. Because I want to built career as a freelancer. I also offer the bid rate low too.
Kindly inform me others terms and condition
Thank you