Conditional filtering of table into seperate sheet including active hyperlink

Hi all,

Apologies if this query has been asked before, I couldn't find any thread that captured exactly what I'm looking for.

I have a large table consisting of a number of columns. Whilst I can ask its users to use Autofilter to define the value of a certain column (or multiple columns), some might actually struggle with that and having to look at a large dataset is also not very 'clean'.

What I'd like to do is to allow users to filter in a seperate sheet by as many categories (=column headers) as they wish. As a result of what they select, matching records show up below.
I guess this might be some kind of 'conditional filtering'

I have tried pivots and vlookups but haven't be able to get this requirement setup properly.

There is a need to 'pull' active hyperlinks as well from the other sheet, which I know is not very straightforward as well.

Would be great if any of you had an idea how to build up this structure!

Attached is a sample of what I'm looking for (with a much simpler table for sample purpose).

Thanks for your help,

Allard

Hi Fotis,

Thank you very much, this really helps.
There is just one missing aspect to the solution, which would be the process to select a unique condition from the categories at the top (eg. Silver), rather than typing it in.
The way I would see it is that there could be a drop-down list matching the unique values in the database sheet? I have tried doing this but failed unfortunately.

Also, do you know whether there is a way for hyperlinks shown to be active straight away? At the moment cells need to be double-clicked for this to be done.