Dear all

I am looking for the easiest way to make an excel-sheet that allows the user to see a selection of the entries in a gross list (one sheet), with a range of criteria in the last column.

E.g.:

Person A - Adress - Phone - X - Y - Z

Then I would like to have sheets X, Y, Z that list all the entries of the persons with a Yes in column X, Y, Z.

I think I need to code a macro and have a front page sheet, where the user clicks a "update"-button running the macro (which I understand in principle, but I don't know how to do it). Is this the case, or is there a simpler way of doing this?

Best regards,
gbnitram