How to insert Multiple Filters or Write VBA or Excel way to filter

pupadhya

New member
Joined
Sep 18, 2013
Messages
1
Reaction score
0
Points
0
Dear All,

We are into aviation training; and we have several instructors conducting classes different batches, so I have created Excel file along with Batch details and I have assigned Instructors as per the classes according to the date. Now I have excel sheet where 4 batches are running simultaneously and I have assigned same instructor into different batch as per his availability.

My requirement:

I wanted to filter Instructor name across different batches, so that I get to know his utilization into different batches and when is he busy doing what classes.

Example: I have file table like this:
CLASS/TIME SFI GSI
ELT-GS/1000-1800 DEV GHOSH

I have the above table for multiple batches, so now when I filter, I would like which batches where SFI(Instructor) DEV GHOSH involved across all the 4 batches in the table.

I have attached my file for your reference, please help me how can i inert multiple filters into different batches so that i get to know the utilization of one instructor.

Please help.
Regards,
Pramod
 

Attachments

  • Instructor Utilization Sheet.xlsx
    27.3 KB · Views: 12
Top