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.
Bookmarks