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.
23 freelancers are bidding on average $73 for this job
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