We have a list of keywords in column A in excel,. We would like to be able to produce an output file that goes to specific websites/comparison shopping sites and produces a list of the lowest price found on each site for the given keywords in a new column for each site. A new tab would be created with the Date the Macro/Script was run, so we can run it every day if desired and compare to what pricing was for any other day. Would you know how to get this done?
See attached file for example....(all prices are just for example and not accurate)