Hello,

I am trying to setup a worksheet where a particular column is auto-filtered based on a cell value (which is not part of the column being filtered) which value is manually entered. For example, in the picture below, if C2 = "A", I'd like the autofilter in column C (ENTRY) to select only lines with "A". Can someone please share a way or VBA code to accomplish this?

Many thanks

Conditional Filtering - Excel 2007.jpg