Results 1 to 1 of 1

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •