I have an excel spreadsheet that lists the names of all employees along with
their supervisors. I also have another spreadsheet that contains the stats
by day for each associate. This contains many records. What I would like to
do is create a pivot table and be able to pull up the records of all
associates assigned to a particular supervisor. The spreadsheet that
contains the stats by day does not list the supervisor for that employee, and
I have been asked to fix this. How would I go about doing this without
manually referencing each employee to their respective supervisor. Each
employee has about 200 records so it could be quite time consuming.