I have created an automation that will read two columns from a Excel sheet containing rows of names. The first columns names are in Japanese, and the second columns names are in English.
With that information, I want to search for each name on a web site, using the Japanese version to search with and then data scrape the content. For each person scraped, I have created an automation to Copy and move the data scraped contents file to a new location and then change the name of it, where I would like to input the English names column row, if that makes sense.
So all in all, I have a excel sheet with two columns (A and B) and I would like to do a For Each Row loop on both of them, but only use the A column for searching and B column for saving the file.
Is there anyone out there who have had a similar problem and/or a solution? I really need help and would like to know how to solve this issue!