seanjon
New Member
- Joined
- Dec 23, 2017
- Messages
- 15
- Office Version
- 2019
- Platform
- Windows
Good day.
I need expert level assistance. I am trying to create a VBA controlled information sorting and display for the training of my team members. I just manually entered who is qualified in what and it took me the better part of a day. With 22 employees and over 200 tasks, updating this monthly is too time consuming. Here is what I am looking at:
Sheet 2 (RAW DATA) lists all the employees and all the training they are certified in, within 90 days of going overdue, and decertified in.
Sheet 1 (TEAM TRAINING) compiles all of this to a 1 stop shop for my manager and I to look at the entire team.
I want the VBA to look up each course code, (Column A) Reference the Employees (Row C1-F1) and go to Sheet 2 to see if they have the code 100 or 200 in Column F. If so, I want an ‘X’ in the corresponding box under their name for that course code back on Sheet 1.
I have included an example workbook with the names and the courses changed
Thank you very much.
I need expert level assistance. I am trying to create a VBA controlled information sorting and display for the training of my team members. I just manually entered who is qualified in what and it took me the better part of a day. With 22 employees and over 200 tasks, updating this monthly is too time consuming. Here is what I am looking at:
Sheet 2 (RAW DATA) lists all the employees and all the training they are certified in, within 90 days of going overdue, and decertified in.
Sheet 1 (TEAM TRAINING) compiles all of this to a 1 stop shop for my manager and I to look at the entire team.
I want the VBA to look up each course code, (Column A) Reference the Employees (Row C1-F1) and go to Sheet 2 to see if they have the code 100 or 200 in Column F. If so, I want an ‘X’ in the corresponding box under their name for that course code back on Sheet 1.
I have included an example workbook with the names and the courses changed
Thank you very much.