2022-04-29

How to Get web data based on link in excel cell?

I'd like to create an Excel sheet, where in one column there is a link to a website like this: enter image description here

Link in column A where there is a MAC add in that url that changes from line to line rest of link is geraric. and it takes the info in the 2 lines marked with arrows and put into another cell. This should be possible for multiple links in different rows from websites with the same structure.

How can I make the web query to be based on the link in the adjacent cell?



No comments:

Post a Comment