Hi, I’m trying to use “For Each” row in excel to do web scraping by "Get Text. The “Get Text” work normally but I only get the last row of the data in excel.
For example, I try to get temperature of each day in June 2022, so I list all the date in June in excel file and use “For Each” row in excel to scrape them from web. The result will always end up a data of 30th June every day. If I change the last row in excel file to 29th June it will end up a data of 29th June every day. The loop open web for each day as intend but not the data.
Thank you in advance.