Hi! Wondering if anyone could help me. This is a small sample of a very large excel database that I set up. (Please see attached worksheet.) I am trying to figure out a way how I could just click on a particular "Investor" and get an automatic list of all entities he is invested in based on the "x" , “f”, or “j” marked in the cells. I need to use it both ways also, by clicking on an entity (in header row), how could I automatically see who is invested in that entity based on the "x" marked in the cells. Also, is there a way of linking the results onto another worksheet? Thanks
Bookmarks