Hi

Does anyone know a macro that filter as follows:

Sheet1: Table: Name

1 Name
2 Fred
3 Bill
4 Jane

Sheet2: Active Cell: "Fred, Bill"

I want to filter the Name table in Sheet A based on those names that are contained in the current active cell in Sheet 2 (list of names comma separated). In this case I would expect the table to show only row 2 and 3.

Any help appreciated!

Cheers