G
Guest
This is what I have:
Worksheet that basically has Columns A:Q with headers Last Name, First Name,
Badge Number, Supervisor, etc. and then the rest contain course names such as
Hazcom, Hazmat, etc.
The way that I have the sheet set up is if a user "John Doe" with
Supervervisor "XYZ" has taken a course they get a 1 if they haven't they get
a 0. What I need to do is on seperate sheets within the workbook based on the
course and if they contain a 0 generate a list including (Last Name, First
Name and Supervisor "columns A, B, and F" for instance). So if there are 12
different courses it would generate 12 different sheets such as Hazcom,
Hazmat, etc.
Any help would be greatly appreciated.
Worksheet that basically has Columns A:Q with headers Last Name, First Name,
Badge Number, Supervisor, etc. and then the rest contain course names such as
Hazcom, Hazmat, etc.
The way that I have the sheet set up is if a user "John Doe" with
Supervervisor "XYZ" has taken a course they get a 1 if they haven't they get
a 0. What I need to do is on seperate sheets within the workbook based on the
course and if they contain a 0 generate a list including (Last Name, First
Name and Supervisor "columns A, B, and F" for instance). So if there are 12
different courses it would generate 12 different sheets such as Hazcom,
Hazmat, etc.
Any help would be greatly appreciated.