Link custom views to specific cells

I have a workbook with two sheets. One lists document names in one column and their associated points of contact (POCs) in another column. The other sheet lists all the POCs. I'd like POCs to be able to click on their name in the POC list and then see only the documents for which they are responsible. I got one cell in the POC list to work using "Worksheet_SelectionChange," but I can't figure out how to replicate that functionality for all the other POCs in the list.

I understand that users can simply filter on their name, but we're dealing with folks who know nothing about Excel, so we need to make this as easy as possible for them. (I work for the USDA, so we're talking about an extremely diverse user audience.)

Any help with this would be much appreciated.

Something like this? Enter a name or portion thereof into the fields in row 11. Copy down, etc. . . Maybe you can make it work for your team.

Pete

I don't think that's going to work. We want to show the user a list of their documents, not a document count.

It's not a document count Wordwrkr. Replace the numbers in column B with the document names and it'll list those docs that belong to them. Change the names in col. A to those of your colleagues.