Pull all the data into a single table in Excel and make sure it includes a column for the faculty.
Then you can create a pivot table that filters by faculty. This will give you a dynamic table that can display each faculty by choosing a dropdown filter or you can duplicate it on multiple sheets with a different filter chosen on each.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|