AutoFilter a Table based on a Cell Value

[skifizzo]

Hi Everyone,

I'm trying to filter a table based on a cell value (B2).

For example, if I type "Red" in cell B2, all the table will be sorted to show me only the "Red" values in the column called "Color".
I tried with this code but it doesn't work.

Please Login or Register  to view this content.

Any idea? I've attached my file.

Thanks in advance!

[Fluff13]

Put the word Color in B1 & try this

Please Login or Register  to view this content.

[skifizzo]

Thanks Fluff13, it work perfectly! You're the man!!

[Fluff13]

You're welcome & thanks for the feedback.

[Fluff13]

As you're using a table, this would be better, as it will always filter the table regardless of size

Please Login or Register  to view this content.