In my use case I have 2 sheets
Sheet one contains a table within one column having links and another column has some name in it. If you look at the image, I am talking about the column W and Z
So when I open each link in column Z, it opens in browser and has a table which can have few rows of data (varies from link to link)
I have already written a For loop to open each link and copy the data table in that link and past it in sheet 2 (column A-E which is automatically pasted by workflow and the data for next link is appended).
Now where I am stuck is, for each link in sheet one, there is corresponding name in W column which I want to past in sheet 2 column F.
Example, if I open link one, there are 2 rows of data in the data table on the website which is pasted in sheet 2 and for both these rows, of data I want to write the cell value in W adjacent to link 1 which is Alfa
Could someone suggest?