look up data based on UPC and add data to Excel document
This project received 24 bids from talented freelancers with an average bid price of $72 USD.Get free quotes for a project like this
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 [url removed, login to view], 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 [url removed, login to view] brings up this page: [url removed, login to view]
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online