Hello, I have a list of a LOT of UPCs in column A of a workbook. In column B, I want a macro to search all the UPCs and return the ASIN for the first product to show up if you search the corresponding UPC in column A in to Amazon. Does anything know how to write a macro like this? It would save so much time. Thanks
This looks fairly straightforward, using PowerQuery:
Can you provide some sample UPCs / expected ASINs to test?
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks