Hyperlinking to a row in a filter

[eviMogwai]

I have set up a database of sorts which is usable through the filter function in excel.
It is setup in a single worksheet as rows of data entries sorted into different columns

Within this database I'd like to hyperlink to whole rows within the sheet.

What I've done this far is to hyperlink to a range of cells (i.e. A1:A16) but this of course doesn't work when filtering.

In my searches I have found that hyperlinking to a cell reference works even through filtering but that you cannot name a row.

Any ideas?

 

[eviMogwai]

Shameless bump

Might there be a way to reference to cells relative to a named cell?
Or is VBA programming a better bet?

 

[eviMogwai]

It is entirely possible to name a range of cells, just make sure to use correct syntax when naming them.

After that there is no problem to hyperlink to a named range of cells

[SOLVED]