I have created a workbook where I want any individual employee to select a
supervisor and on a seperate worksheet it will show everyone that reports to
that person. Currently I have linked the two sheets and the supervisor name
appears in cell B1 however I can't get my data (all emplopyees) to
auto-filter down to just that supervisor. Is there anyway to do this? I'm
thinking it may be a VBA since I can not get the auto-filter to change just
based on B1. thanks!