Hi,
I have an excel table with Customer names etc. This includes a column called "Active which has values of "Yes" if the customer is still active.
I'm trying to use Data validation in another worksheet to display only those customers where "Active" = "Yes".

I would prefer to use a function rather than VBA.