Hi guys,

A sheet I've made contains;

A table with these data:
Name (30k rows) | Links
A|
B|

And a database with:
Name (50k rows) | Links
A|www.google.com/cow
A|www.google.com/chicken
A|www.google.com/rat

B|www.google.com/cow
B|www.google.com/elephant

What I would like to do is to make multiple dynamic hyperlinks in, preferably one, column(s) "Links", since there could be more around 20 "Animals" in the database per "Name".
Next, I would like to be able to sort the table based on the "Animals" when there is an occurrence in one of the hyperlinks.

What would be the nicest way to do this with VBA?
I was thinking about a comment with multiple hyperlinks, but didn't manage to do that. Furthermore, this was not sortable.

Thanks in advance,

With best regards,

Max