Hello, I am creating a bot that is supposed to extract values from a website from values in column A in an excel worksheet.
Firstly, my bot loops through an excel sheet copies and pastes the values of each row into a website one at a time (the values from column A). So, I’ve managed to execute this successfully. However, I need the bot to stop in the first iteration to extract specific values for the first value in row 1 column A(I need to repeat this for row 1… row n). How can I accomplish this in the middle of the loop? So, basically first loop copy value from first row of column A > paste into search bar > execute search > extract values of the specific page (for the first row in column A) > second loop repeats and so on.