ExcelHelpNecessary
New member
- Joined
- Jan 14, 2021
- Messages
- 5
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
[FONT="]I'm trying to create a staff training log in excel. I've tried various methods and none of them are really getting me 100% to where I want to be.[/FONT]
[FONT="]My requirements are:[/FONT]
[FONT="]My requirements are:[/FONT]
- Staff List
- Course List
- Ability to select staff member from dropdown, a list will appear detailing the courses they have taken
- Ability to select course from a dropdown, a list will appear detailing the staff members that have taken this course
- VLOOKUP
- Data Validation
- Pre-existing template
- Filters