Data Validation based on column value

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.

Please ignore this thread. I found the answer in another thread.
Thanks anyway