Hello! I have built a process that goes to yahoo finance, searches a company name, then pulls three separate values from x-paths the pastes them in excel.
I want to do this on a larger scale instead of just searching for one company name. I have tried using a for each loop to do this. I am pulling values from column A then want values to be returned in column B, column C, and Column D. The values I want returned are from the Xpaths. What do I need to do in order to do this? Attached is an image of the process for 1 company that I am trying to do for a whole list. Gets confusing for me when picking where to have data end up.