How to make table in excel using hyperlinks in excel?

[Osamu9Dazai]

Hello, just very interested in how to make table by VBA that takes information from hyperlinks and inserts it in table . So the task asks to:
1)Create a VBA procedure that creates a data table on the Table worksheet based on the data from the European Parliament worksheet with columns: Name, country, party/faction (definitely in this order).
2)Hyperlinks in the data should also appear in the ordered table (ie, the cells should be copied).
3)Color the background of the row cells of the result table red (index 3) if the member of parliament belongs to the Uueneva Euroopa fraktsiooni
4)The procedure must first remove the previous data from the result table (headers remain)
On image you can see hyperlinks.
Would appreciate the help!

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to make table in excel using hyperlinks in excel?
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.