I came into a problem automating this project where I have to extract data from an excel sheet.
Firstly, I have to open the Hyperlinks given in column Date like November 2020, etc.
Then, from that hyperlink, I have to extract data.
I am not able to loop through the table so that it clicks on every hyperlink and extracts the data.
Please give a solution.