How to click hyperlink

Hi
How to click hyperlink in Gsheet where in a column each cell has different hyperlink name means how to use click activity dynamiclly inside a loop when the hyperlink name differs in each cell

@Saranya_Amar,

You can use macro for this,

  1. get total rows
  2. put for each on those rows
  3. write a logic to click a hyperlink.

plz explore on google, you could find a solution.

Cheers,
Pankaj