I am not quite sure how to accomplish this. I am open to any suggestions. If i have a list of keywords in an excel spreadsheet in Column A, I want to be able to run a macro that will take that keyword, plug it into a search tool on a specific web page, then from the results table, extract a unique ID number and populate that unique ID number next to the keyword in column B in the excel file and work its way automatically through the entire list in column A until all terms in column A have been searched and their respective unique ID numbers are in Column B.
Can this be done?
Can this be done?
